子表中两个字符串相加

最新推荐文章于 2024-05-06 19:43:31 发布

原创最新推荐文章于 2024-05-06 19:43:31 发布 · 1.4k 阅读

CC 4.0 BY-SA版权

 DECLARE @B TABLE(IP VARCHAR(15),TICKETID VARCHAR(15))
INSERT INTO @B 
SELECT '1.1.1.1','A' UNION ALL
SELECT '2.2.2.2','A' UNION ALL
SELECT '3.3.3.3','A' UNION ALL
SELECT '4.4.4.4','B' 

SELECT    TICKETID AS TICKETID, 
        STUFF(
             (SELECT ', '  + CONVERT(VARCHAR,IP)  FROM @B T1 WHERE T1.TICKETID = T2.TICKETID FOR XML PATH('')),1,1,''
           ) AS IP
FROM @B T2 GROUP BY TICKETID