select
A.GroupSeq,
replace(( select name as [data()]
from Table
where A.GroupSeq=GroupSeq
for xml path(”)),’ ‘,’,’) as Member
from [Table] as A
group by GroupSeq
Just another WordPress site
select
A.GroupSeq,
replace(( select name as [data()]
from Table
where A.GroupSeq=GroupSeq
for xml path(”)),’ ‘,’,’) as Member
from [Table] as A
group by GroupSeq