行转列

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,''),

posted @ 2014-11-07 09:25  小菜鸟飞飞  阅读(215)  评论(0)    收藏  举报