34,590
社区成员
发帖
与我相关
我的任务
分享
;WITH cte AS (
select 'aaa' col,'bb' col1,1 col3 union all
select 'ddd' col,'dd' col1,1 col3 union all
select 'gg' col, 'ff' col1,2 col3
)
SELECT STUFF(( SELECT '+' + col
FROM cte WHERE col3=t.col3
FOR
XML PATH('')
), 1, 1, '') AS col , STUFF(( SELECT '+' + col1
FROM cte WHERE col3=t.col3
FOR
XML PATH('')
), 1, 1, '') AS col1,t.col3
FROM cte as t
GROUP BY t.col3
;WITH cte AS (
select 'aaa' col,'bb' col1,1 col3 union all
select 'ddd' col,'dd' col1,1 col3 union all
select 'gg' col, 'ff' col1,2 col3
)
SELECT STUFF(( SELECT '+' + col
FROM cte WHERE col3=t.col3
FOR
XML PATH('')
), 1, 1, '') AS col , STUFF(( SELECT '+' + col1
FROM cte WHERE col3=t.col3
FOR
XML PATH('')
), 1, 1, '') AS col1,t.col3
FROM (SELECT DISTINCT col3 FROM cte)t
GROUP BY t.col3
;WITH cte AS (
select 'aaa' AS col1,'bb' AS col2 union all
select 'ddd','dd'
)
SELECT STUFF(( SELECT '+' + col1
FROM cte
FOR
XML PATH('')
), 1, 1, '') + ',' + STUFF(( SELECT '+' + col2
FROM cte
FOR
XML PATH('')
), 1, 1, '') AS col
SELECT ID,
STUFF((SELECT '+'+PAR1 FROM A K1 WHERE KK.ID=K1.ID FOR XML PATH('')),1,1,'') AS UU1,
STUFF((SELECT '+'+PAR2 FROM A K1 WHERE KK.ID=K1.ID FOR XML PATH('')),1,1,'') AS UU2 FROM A KK
GROP BY ID