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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2007-09-05 : 18:58:54
|
| Guys, a quick question.One field with Time from 12 am TILL 1159 PMExample12:00:0112:00:1012:00:20.....23:59:30I want to calculate differnace from from 1 entry and second entry, then between second and third and so on.....12:00:01 012:00:10 1012:00:20 10 .....23:15:3023:59:30 2640I want this through one query?Any help or guidelines please?Thanks in advance..SKR |
|
|
Koji Matsumura
Posting Yak Master
141 Posts |
Posted - 2007-09-05 : 21:47:18
|
| Please post ddl and sample data. |
 |
|
|
|
|
|
Time Differance Caluclation