I am writing the stored procedure and I want to do something like this:

I have a table called "abc" and here is the sample data of table abc .

Columns ==> a b c d
=== === === ===
a a a a
a a a b
a a a c
b b b x
b b b y
b b b z

And I want the data in a following format in a different table.

Columns ==> a1 b1 c1 d1
=== === === ===
a a a a,b,c
b b b x,y,z

Is there any way to do above without using cursors; (using temp tables).
I have a large data and It is very slow with the cursors.

Anyidea?

Thanks in advance !!!
MS Sql Server LazyDBA home page