Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2003-12-29 : 07:27:24
|
| hi,I have a table of task with time:select taskid, startTime, endTime from Taskswhen no task was running ? ( i need it by ranges of time )many thanksNoam Graizer |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-29 : 08:55:49
|
| Why not post the DDL and some sample data, and think about what you're asking...If task 1 ends at 12:00:00.001 and task 2 doesn't start until 12:00:00.051...would yo uconsider 50 milliseconds a time when no task is running?Brett8-) |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-12-29 : 09:42:33
|
| Very interesting....What's the start time for this report? I'm sure no task was running when Columbus crossed the ocean.SELECT @MinStarttime = MIN(StartTime)FROM MyTableI solved a small part of the problem by establishing a lower boundry.I'll leave the clean-up on this problem to Brett. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-29 : 09:58:51
|
quote:
Originally posted by SamC
Very interesting....What's the start time for this report? I'm sure no task was running when Columbus crossed the ocean.SELECT @MinStarttime = MIN(StartTeim)FROM MyTableI solved a small part of the problem by establishing a lower boundry.I'll leave the clean-up on this problem to Brett.
You're a peach.... Need the DDL ans some answers first...Brett8-) |
|
|
|
|
|
|
time cross-cut