实现类似mysql group_concat的功能

SELECT SG.Id 
      ,SG.GroupName  
      ,HostNames = STUFF((SELECT ',' + SH.[HostName]
          FROM SaltHost SH
          WHERE SG.Id = SH.HostGroupId
          FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
FROM [SaltGroup] SG
ORDER BY SG.Id

posted on 2017-01-15 19:56 kaynet 阅读(1964) 评论(0) 编辑收藏举报