SELECT stuff((SELECT ',' + lotno FROM(SELECT DISTINCT d.lotno FROM m_PrintSplitRecord_t d
LEFT JOIN m_WhStroeCarton_t t ON t.Cartonid=d.ppid
WHERE t.Usey='S' AND
d.partid='Y.001.00082' AND d.makedate<'20211023'
)b
for xml path('')),1,1,'') AS aa
SQL SERVER将多行数据合并成一行(转载) sqlserver
https://www.cnblogs.com/johnwood/p/6386613.html