sql分组合并

select * from dbo.[User]

select sqr,stuff((select ','+rtrim(xdr)
from dbo.[User]
where sqr=a.sqr for xml path('')
),1,1,'') as [xdrs]
from (select distinct sqr from dbo.[User]) a