|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 01/08/2013 : 06:59:42
|
I suspect you need to define what you want a bit more precisely but
insert tbl
select t1.id, t1.timeout, t2.timein
from tbl t1
join tbl t2
on t1.id = t2.id
and t1.timein < t2.timein
==========================================
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. |
 |
|
Generate new Row After Calculation
