sql pivot 能否将多行字符串合并成一行

[ying_wzm]

能否将表中同一DeclareID的ContractNo数据合并成：
37SI12040,37SI12015,37SI12009,37SI12001,36SI12018X,37SI12018,37SI12023,37SI12035,37SI12045
这一长串的字符串 一行显示，838 37SI12040,37SI12015,37SI12009,37SI12001,36SI12018X,37SI12018,37SI12023,37SI12035,37SI12045
各位大神，帮帮忙

[RINK_1]

if OBJECT_ID(N'TEMPDB..#T') IS NOT NULL
DROP TABLE #T
GO

CREATE TABLE #T
(DECLAREID VARCHAR(10),
 C VARCHAR(10),
 CONTRACTNO VARCHAR(10))
 GO
 
 INSERT INTO #T
 SELECT '838','331(C)','37SI12018' union all
 SELECT '838','332(C)','37SI12015' union all
 SELECT '838','372(C)','36SI12018' union all
 SELECT '838','392(C)','37SI12001' union all
 SELECT '838','393(C)','37SI12009' union all
 SELECT '838','331(C)','37SI12023' 
 
 
SELECT DECLAREID,
       STUFF((SELECT ','+CONTRACTNO FROM #T WHERE DECLAREID=A.DECLAREID FOR XML PATH('')),1,1,'') AS CONTRACNO_LIST
FROM #T A
GROUP BY DECLAREID

[Andy__Huang]

declare @s varchar(2000)
set @s=''
select @s=@s+','+ContractNo
from AppLoginLog
print stuff(@s,1,1,'')

[Andy__Huang]

declare @s varchar(2000) set @s='' select @s=@s+','+ContractNo from 你的表 print stuff(@s,1,1,'')

[ying_wzm]

谢谢各位大神