SQL 多行合并字段的新解决办法

今天正好用到，搜了一下，照着网上说的写了遍。

 

SELECT *
FROM(
    SELECT DISTINCT
        registryid
    FROM certificate
)A
OUTER APPLY(
    SELECT
        [values]= STUFF(REPLACE(REPLACE(
            (
                SELECT D.ItemName FROM certificate C
    left join dictionary D on C.certificatetype = D.ItemCode
                WHERE registryid = A.registryid
                FOR XML AUTO
            ), '<D ItemName="', ','), '"/>', ''), 1, 1, '')
)C

 

 

 

如上所示