MS SQL Server - Query to Calc End Time

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Query to Calc End Time

Don

2006-10-24, 6:37 pm

I have a system that tracks steps of job runs. The users only enter the
start time of each step. What's a good way to calc the end time of each step
in a query. The last step of the job run is called end run so it's both the
start and end date. Multiple jobs can run at the same time. The calculated
end time for the example below is 10:35 am, 11:45 am, 11:45 am, 2:30 pm, 4:35
pm, 4:35 pm

Thanks

Don

The table looks like this
Detail ID Job No. Start Time
17 3 9:35 AM
22 3 10:35 am
25 3 11:45 am
18 4 10:30 am
20 4 2:30 pm
21 4 4:35 pm

Sponsored Links