>>>Check http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6216
>>>or google:dynamic pivoting in sql server 2000
>>
>>Hi Boris,
>>
>>George Mastros has a blog on Pivoting in SQL 2000, although not dynamic. It's easy to turn it to dynamic, of course:
>>
>>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/understanding-sql-server-2000-pivot
>>
>>BTW, the usual answer is to perform transformation on the client (in the Reporting tool), not in T-SQL.
>
>
>My mistake, Ignore it :-)

About each 5th question in MSDN forum is PIVOT or dynamic PIVOT. I think I'll start having nightmares about it :)