Home Forums SQL Server 7,2000 T-SQL SQL PIVOT problem RE: SQL PIVOT problem
Terry Troisi
SSC-Addicted
Points: 430
More actions
July 29, 2013 at 12:29 pm
#1636739
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