Listing 2: Using Dynamic SQL with PIVOT

SELECT STUFF(
  (SELECT N',' + QUOTENAME(ShipperID) AS [text()]
   FROM dbo.Shippers
   ORDER BY ShipperID
   FOR XML PATH('')), 1, 1, N'');