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)
 Pivot issue

Author  Topic 

rupalim
Starting Member

20 Posts
Posted - 2010-10-16 : 08:45:52
Hi,
Plz may i knw how to convert columns into rows dynamically
.

TG
Master Smack Fu Yak Hacker

6065 Posts
Posted - 2010-10-16 : 09:20:50
Search for it here "dynamic pivot". There are pages of topics. There's also this blog:

http://beyondrelational.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx


Be One with the Optimizer
TG
Go to Top of Page

glendcruz
Yak Posting Veteran

60 Posts
Posted - 2010-10-16 : 23:09:25
Provide an example and the result required, some Guru will work it out.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site