行转列

STUFF((SELECT '+'+m.MProjectName FROM dbo.Maintenance m WITH(NOLOCK) WHERE m.ID IN(SELECT item FROM dbo.Split(cs.MIDs,',')) FOR XML PATH('')),1,1,''),

原文地址:https://www.cnblogs.com/q101301/p/4080440.html