CREATE view vw_Cust_kaocha_man_list
as
select mainID,
isnull(STUFF((SELECT ','+Convert(varchar(100),LinkManID) FROM vw_Cust_kaocha_man WHERE mainID=A.mainID FOR XML PATH('')),1,1,''),'') AS LinkManIDs,
isnull(STUFF((SELECT ','+Convert(varchar(100),Name) FROM vw_Cust_kaocha_man WHERE mainID=A.mainID FOR XML PATH('')),1,1,''),'') AS LinkManNames
from vw_Cust_kaocha_man A group by mainID
sqlserver常用视图,多行转为一列并用符号隔开
最新推荐文章于 2021-02-28 10:56:12 发布