Listing 1: Workaround for PIVOT's Implicit-Grouping Limitation

SELECT *
FROM (SELECT EmployeeID, ShipVia,
  Freight FROM dbo.Orders) AS D
  PIVOT(SUM(Freight)
    FOR ShipVia IN([1],[2],[3])) AS P;