Below is simple sql that does that

declare @res varchar(Max)

select @res = coalesce(@res + ',', '') + [name]

from

(

select 'Apple' as name,...