Here is another solution to the problem that I usually use.

declare @res varchar(max)

select @res = isnull(@res + ', ', '') + name from table_source order by id

select @res

Here table_source can...