Thanks for the help.

I tried the first example (because it looked simple) but how do I incorporate

declare @str varchar(1000)

select @str = coalesce(@str,'') + name + ', '

from tbl

select...