Format Table

[LeoLionHeart]

Hi there I have a table such as the following:

Name ID
Bob green
Bob red
Bob blue
Dave black
Dave green

I want to place it into a table that reads

Name ID
Bob green,red,blue
Dave black,green

Do I need to use a cursor for this.

Any help would be appreciated.

 

[vongrunt]

http://www.nigelrivett.net/SQLTsql/CSVStringFromTableEntries.html

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