how to convert row to column - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how to convert row to column

Author

Topic

zubamark
Starting Member

23 Posts

Posted - 2013-04-09 : 10:48:10

Have dynamic data:
C1 C2
A 1
B 2
C 3
D 4
....
Need:
C1 C2 C3 C4 .................
A B C D .................
1 2 3 4 .................

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-04-09 : 15:11:48

use excel or this method:

http://beyondrelational.com/modules/2/blogs/70/posts/10840/dynamic-pivot-in-sql-server-2005.aspx

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources