动态sql ,表如下,sp 内容多样,有可能多达几十个
name sp
1 a
1 b
2 a
2 c
期望结果
name sp_name
1 a,b
2 a,c
动态sql ,表如下,sp 内容多样,有可能多达几十个
name sp
1 a
1 b
2 a
2 c
期望结果
name sp_name
1 a,b
2 a,c
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