• That's correct. Pivot was introduced in SQL 2005.

    You can use CASE to pivot in SQL 2000 (or all other versions for that matter). Here's an example:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/951ad7d4-d21e-4a13-9a5b-5d156fe3d90d/aggregated-case-expressions-versus-the-pivot-operator-is-one-better-than-the-other