主题：合并字符串

SELECT

    编码,sum(数量) as 数量小计,

    申购单号 = (

               STUFF(

                    (SELECT ',' + 申购单号

                     FROM db_sgoulist

                     WHERE 编码 = A.编码

                     FOR xml path('')

                    ),1,1,''

                    )

                 )

FROM db_sgoulist as A

GROUP by 编码