22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #t_AQQ
(ID INT,MYCON VARCHAR(20))
INSERT INTO #t_AQQ
SELECT '1','jack'
UNION ALL
SELECT '1','abc'
UNION ALL
SELECT '2','aaa'
SELECT t1.ID ,
mycon=STUFF((SELECT ','+[mycon] FROM #t_AQQ t WHERE t.ID=t1.ID FOR XML PATH('')), 1, 1, '')
FROM #t_AQQ t1
GROUP BY t1.ID
drop table #t_AQQ
/*
(3 行受影响)
ID mycon
----------- -------
1 jack,abc
2 aaa
(2 行受影响)
*/
;with tb(no, name)
as
(
select 1 ,'jack' union all
select 1 ,'abc' union all
select 2 ,'aaa'
)
select no,
stuff(cast((select ','+ name from tb t2 where t1.no = t2.no for xml path('')) as varchar(2000)),1,1,'') as name
from tb t1
group by no
/*
no name
1 jack,abc
2 aaa
*/