HOW could i DO PIVOTING in SQL SERVER 2000

[MrMob]

Plz teach me to do that...

[nbiswas]

HOW could i DO PIVOTING in SQL SERVER 2000

Try this

Pivot Table Data in SQL Server 2000 and 2005

Pivoting in SQL SERVER 2000 is achieved by using a combination of

a) Aggregate function(e.g. SUM, MAX, MIN etc.)

b) CASE STATEMENT

I hope this article will help you.