深藍色論壇

代碼: 選擇全部

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 ;