动态sql 帮看一下啊，行专列

Question

动态sql ，表如下，sp 内容多样，有可能多达几十个
name sp

---

1 a
1 b
2 a
2 c

期望结果
name sp_name
1 a,b
2 a,c

Answer 1

select A.ID,  STUFF((select ','+ SP from [Test1] where ID=A.ID for xml path('')),1,1,'') AS SP_NAME
from [dbo].[Test1] A GROUP BY A.ID