Good Morning,

I have a 2 column table like below, where there is a variable number of procedure codes for hundreds of test codes:

TC PC
1234 ABC
1234 DEF
1234 GHI
1234 JKL
5678 MNO
5678 PQR

And I want to make it like this.

TC PC
1234 ABC, DEF, GHI, JKL
5678 MNO, PQR


There are 8 million rows in the table.

First, is it possible accomplish this with TSQL?

Any links that might assist my reserach would be great also.

Thanks in advance for any help, BPH

Please check the following thread:
http://bytes.com/topic/sql-server/an...s-into-columns

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

Thanks. I'm perusing that info and hopefully can draw a solution from knowledge gained.