Hi,

if you have the row number for the table already you could join this table in on itself as below allow you to join one row to the next

SELECTtable1.column1,

table2.column2

FROM Sampletable as table 1

LEFT OUTER JOIN Sampletable as table2

ON table1.rownumber+1 = table2.rownumber