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:
a.RowNumber
,a.name
,a.dQty
,a.Price
,b.RowNumber
,b.name
,b.dQty
,b.Price
FROM
MyTable a
LEFT...