行转列

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  小菜鸟飞飞  阅读(211)  评论(0编辑  收藏  举报