Figure 11 Result of a PIVOT
กก
SalesPersonID 2001            2002            2003          2004
------------ -------------- -------------------- --------------
20            NULL            NULL            197303.2486   31680.0348
33            569966.4019     1475303.3042    1693905.5061  685729.9303
29            1665446.9384    3104537.8510    2720479.1674  1311261.2956
•••

(18 row(s) affected)