select id, [val]=(  
select [value] +',' from tb as b where b.id = a.id for xml path('')
) from tb as a  
group by id  

select id, [val]=stuff((  
select ','+[value] from tb as b where b.id = a.id for xml path('')),1,1,'')
from tb as a  
group by id