Seems easy and workable... i shall try out on this... hope it really gives me what i wanted... thanks in advance(if works)...
John Mitchell-245523 (1/23/2014)
Fairly simple in T-SQL, as well:
SELECT
a.RowNumber
,a.name
,a.dQty
,a.Price
,b.RowNumber
,b.name
,b.dQty
,b.Price
FROM
MyTable a
LEFT JOIN
MyTable b ON a.RowNUmber + 1 = b.RowNumber and a.RowNumber%2 = 1
John