Concatenate Rows in a table

Hi,
Try like as follows,

SELECT ROW_NUMBER() OVER(PARTITION BY M.id, ORDER BY M.suborder) 'RowNo',
M.id, M.suborder, STUFF((SELECT ','+suborder AS text()
FROM table_name
WHERE ROW_NUMBER() OVER(PARTITION BY id, ORDER BY suborder) <> 1
AND id=M.ID FOR XML PATH(''))),1,1,'') 'OtherSuborders'
FROM table_name M
WHERE ROW_NUMBER() OVER(PARTITION BY M.id, ORDER BY M.suborder) = 1
-- In my PC , I don't have SQL Server, So check and tel me the give Query is fine or not.

Regards,
GVPrabu

What you need is a theoretical concatenation aggregate. Well, the problem is, that there is no such thing in SQL Server 2008R2. But the good new is, that you can make one really easily with the CLR integration (see: http://msdn.microsoft.com/en-us/library/91e6taax(v=vs.80).aspx[^] and http://msdn.microsoft.com/en-us/library/ms182741(v=sql.105).aspx[^]).
It is a really clear and simple solution but you need two things as above: write the code (really simple), deploy and declare the aggregate in the database (for this you need administrative privileges on the server).
Look here: http://www.mssqltips.com/sqlservertip/2022/concat-aggregates-sql-server-clr-function/[^]
An other interesting reading in this topic: https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/[^]