原始情况:
期望结果:
Sql脚本:
SELECT t.qydm ,t.qymc
,
STUFF((SELECT ','+ltrim(display_term)
FROM testDivideWord
WHERE qydm=t.qydm FOR XML PATH('')), 1, 1, '')
AS keyword
FROM testDivideWord t
GROUP BY qydm,qymc