天天看点

使用xmp path进行行变列的SQL语句

(SELECT STUFF(( SELECT '/' + vfm2.EmbassyNames FROM VisaFeeMain AS vfm2

                     WHERE vfm2.id = vfm.id

                    FOR XML PATH('')),1,1,'') AS city ) AS '前往国家'