SELECT P.DocStatus, C.CustomerName FROM vsCustomizationRequest.dbo.CRF_Project P, vsCustomizationRequest.dbo.CustomerList C WHERE C.CustomerName IN (SELECT Value from funcListToTableInt2(@name, ',')) AND P.CustomerID = C.CustomerID GROUP BY C.CustomerName
SELECT CustName ,st=STUFF((SELECT ','+DocStatus FROM yourTable WHERE CustName=A.CustName FOR XML PATH('')) , 1 , 1 , '' ) FROM yourTable A GROUP BY CustName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)