HOW COUld i use POVIT ing sql server 2000

[MrMob]

Coz i tried the Last One on your LIST

[nbiswas]

Solution to HOW COUld i use POVIT ing 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.