akberali67 (6/29/2013)
Hi,Firstly, I Apologize for presenting the data the way I did.
No problem, just remember for next time 😀
akberali67 (6/29/2013)
Just one final question is whether the numbers would be ordered or rather can they be ordered in the 'Sno_Retained' field.Thanks again,
Akber.
If you look at the code in the FOR XML bit, there is an "ORDER BY Sno". So the Sno_Retained will currently be ordered by the Sno. . . e.g, 1,2,3 rather than 3,1,2.