declare @bStartTime DateTime
declare @bEndTime DateTime
declare @sessionid nvarchar(36)
declare rp cursor for
select sessionid from reportprocess
open rp
fetch next from rp into @sessionid
while @@FETCH_STATUS = 0
begin
select @bStartTime = StartTime, @bEndTime = EndTime from dbo.GetNewBusinessHours(@sessionid)
select @sessionid, @bStartTime, @bEndTime
fetch next from rp into @sessionid
end
close rp
deallocate rp