Click here to Skip to main content
16,004,678 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have a column of month and amount like this
month amount
jan 6000
feb 4000


i want to display like this

jan feb ......
6000 4000

plz help me
Posted
Comments
[no name] 25-Apr-14 2:44am    
http://stackoverflow.com/questions/15757634/displaying-columns-as-rows-in-sql-server-2005

I have two options

Front-end
Formatted vertical DataGrid web control[^]

Back-end
Using PIVOT and UNPIVOT[^]
Pivoting data in SQL Server[^](Alternate ways)
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900