代碼: 選擇全部
SELECT DISTINCT
A.busid ,
A.drivername ,
A.insurlistnum ,
STUFF(( SELECT ', ' + insurchildname
FROM @T1 B
WHERE A.busid = B.busid
FOR
XML PATH('')
), 1, 1, '') AS [insurchildname]
FROM @T1 A ;
http://www.dotblogs.com.tw/rainmaker/ar ... 69625.aspx