|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 12/19/2012 : 03:53:59
|
select *, datetime - (select min(datetime) from tbl t2 where t2.datetime > t.datetime)
from tbl t
order by datetime
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
Calculating Time Diff between this row and the nex
