One easy way i like to use is this:
create table #t (id int, name varchar(20))
insert into #t
values (1, 'Matt'), (1, 'Rocks'), (2, 'Stylus')
select id
,Names = stuff((select ', ' + name as [text()]
from #t xt
where xt.id = t.id
for xml path('')), 1, 2, '')
from #t t
group by id
i got the example from here:
http://stackoverflow.com/questions/13639262/optimal-way-to-concatenate-aggregate-strings[
^]
Try searching for "tsql aggregate string concatenation", that should put you on the right path.