How to create comma separated list

[trpnbillie]

Hi. I have a table Employee with ID, Name and Country column

1 John Doe USA
1 John Doe CAN
1 John Doe GBR
2 Sally Jo CAN
2 Sally Jo MEX

I want to produce this result set:

1 John Doe USA, CAN, GBR
2 Sally Jo CAN, MEX

Is there an efficient way to do this without a cursor? (or is cursor my only option?)

thanks for your help!!!

 

[vongrunt]

User-defined function (UDF).

Search this forum, this was done at least 1242342423 times .

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[SQLDenis]

faq183-2146


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[trpnbillie]

The loop is beautiful. HUGE THANKS!!