Thank this author by sharing:
By Nitin Bhargava,
This is a sample script. Copy and paste this query in SQL 2005. First it creates and inserts sample data in Test Table. Then it concatenates the value of col2 for each different value in col1. It is using CTE and recursion to get comma separated values. It avoids the use of cursor.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.