Datediff between two ids of same record

[simma]

Hello
I need to take datediff from consequetive rows in resultset
For example datediff between dates corresponding to seqno 45 and 200 (datediff would be 34).Pleasae advice .I gave up
Thanks

Lnumber lid seqno date
5000037973 68906 45 2003-06-17 00:00:00.000
5000037973 68909 200 2003-07-21 00:00:00.000

Sql
select A.lnumber,B.lid,B.seqno,B.date
from table A
left outer join
table B
on A.aid=b.aid

 

[lienyi]

see thread183-620609

 

[simma]

It works... Thank you