Consulta, lista con comas Coalesce Sql 2005

[progracvb]

thanks...encontré la solucion en http://es.w3support.net/index.php?db=so&id=111341

declare @t table(id int, name varchar(20),somecolumn varchar(10))
insert into @t
select 1,'ABC','X' union all
select 1 ,'ABC','Y' union all
select 1,'ABC','Z' union all
select 2 ,'MNO','R' union all
select 2 ,'MNO','S'

Consulta:

select ID,Name,
stuff((select ',' + CAST(t2.SomeColumn as varchar(10))
from @t t2 where t1.id = t2.id and t1.name = t2.name
for xml path('')),1,1,'') SomeColumn
from @t t1
group by id,Name

Salida:

ID NameSomeColumn
1 ABCX,Y,Z
2 MNOR,S