FOR XML PATH

FOR XML 子句的基本語法
FOR XML PATH 多筆資料合併為一筆
使用自连接、for xml path('')和stuff合并显示多行数据到一行中
FOR XML PATH 语句的应用
[SQL]將多筆資料合併為一筆顯示(FOR XML PATH)
[SQL SERVER][TSQL]多筆資料變單筆資料

select 
( select substring(CLASSGRP,1,LEN(CLASSGRP)-1) 
 from ( 
 select ( 
 select coalesce(CTL_GROUP, '') + ':' + convert(varchar, count(*)) + ',' 
  from COL_STUTEMP_LIST L 
 where L.CTL_SN = S.CTT_SN 
 group by L.CTL_GROUP  
 FOR XML PATH('') 
 ) as CLASSGRP 
 ) a ) as THISGRP 
from S_TEMP S

SQL Server XML Questions You Were Too Shy To Ask