Listing 3: Alternative Method for Using Dynamic SQL with PIVOT

SELECT STUFF(
  (SELECT N',' + QUOTENAME(ShipVia) AS [text()]
   FROM (SELECT DISTINCT ShipVia FROM dbo.Orders) AS D
   ORDER BY ShipVia
   FOR XML PATH('')), 1, 1, N'');