DECLARE @TicketId int
	
DECLARE c1 CURSOR READ_ONLY
FOR
SELECT iHdTicketId
FROM tHdTicket

OPEN c1

FETCH NEXT FROM c1
INTO @TicketId

WHILE @@FETCH_STATUS = 0
BEGIN

	PRINT @TicketId
	exec spUpdateSlaPausedHours @TicketId
	FETCH NEXT FROM c1
	INTO @TicketId

END

CLOSE c1
DEALLOCATE c1