Listing 4: Pivoting Code for DISTINCT String Concatenation, SQL Server 2005
SELECT CustomerID,
 ISNULL([1],'') + ISNULL(','+[2],'') + ISNULL(','+[3],'')
  + ISNULL(','+[4],'') + ISNULL(','+[5],'') AS ArrEmps
FROM (SELECT CustomerID,
    CAST(EmployeeID AS VARCHAR(10)) AS SEmployeeID,
    ROW_NUMBER() OVER(PARTITION BY CustomerID
             ORDER BY EmployeeID) AS n
   FROM (SELECT DISTINCT CustomerID, EmployeeID
      FROM dbo.Orders) AS D1) AS D2
 PIVOT(MAX(SEmployeeID) FOR n IN([1],[2],[3],[4],[5])) AS P;