SELECT (select stuff((SELECT ','+ Phone from dbo.ReservationDetails WHERE ReservationDetailId IN ( SELECT Item FROM dbo.fnSplit(@ReservationDetailId, ',') ) for xml path('')),1,1,'')) AS Mobiles
SELECT (select stuff((SELECT ','+ Phone from dbo.ReservationDetails WHERE ReservationDetailId IN ( SELECT Item FROM dbo.fnSplit(@ReservationDetailId, ',') ) for xml path('')),1,1,'')) AS Mobiles
转载于:https://www.cnblogs.com/dzw159/p/9353077.html