1 select distinct t1.pciBillID,2   STUFF((SELECT  distinct t2.Invoicenumber+ ','3          from TB_PCustomerInvoiceextend t24          where t1.pciBillID = t2.pciBillID5             FOR XML PATH(''), TYPE6             ).value('.', 'NVARCHAR(MAX)') 7         ,1,0,'') data8 from TB_PCustomerInvoiceextend t1) AS Invoicinfo