SQL 相同列字符串列加
/列A相同时 累加列B（字符串）/
SELECT 列A,
列B = (
STUFF(
(
SELECT ‘,’+列B
FROM 表名 WITH(NOLOCK)
WHERE 列A = a.列A FOR XML PATH(”)
),
1,
1,
”
)
)
FROM 表名 as a WITH(NOLOCK)
GROUP BY 列A
/实例 表I_sc_so_lines中ParentObjectID相同时item累加 /
SELECT ParentObjectID,
item = (
STUFF(
(
SELECT ‘,’+item
FROM I_sc_so_lines WITH(NOLOCK)
WHERE ParentObjectID = a.ParentObjectID FOR XML PATH(”)
),
1,
1,
”
)
)
FROM I_sc_so_lines as a WITH(NOLOCK)
GROUP BY ParentObjectID