行转列

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 @   小菜鸟飞飞  阅读(211)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示