sqlserver多行转一行 

SELECT A.OrderIds FROM (SELECT STUFF((SELECT ',' + OrderId FROM InvoiceSingle FOR XML PATH('')),1,1,'') AS OrderIds FROM InvoiceSingle )A GROUP BY OrderIds

 

posted @ 2024-01-19 15:41  亦承  阅读(153)  评论(0)    收藏  举报