Cacher is the code snippet organizer for pro developers

字符串分组聚合

with t  as(  
 select 'Charles' parent, 'William' child union  
 select 'Charles', 'Harry' union  
 select 'Anne', 'Peter' union  
 select 'Anne', 'Zara' union  
 select 'Andrew', 'Beatrice' union  
 select 'Andrew', 'Eugenie'   
)  
  
SELECT parent, STUFF( ( SELECT ','+ child   
                        FROM t a   
                        WHERE b.parent = a.parent   
                        FOR XML PATH('')),1 ,1, '')  children  
FROM t b   
GROUP BY parent  

原始出处:http://www.cnblogs.com/jintan/archive/2009/07/17/1525895.html