how to convert column to row in SQL Server 2005

[Chetan visodiya]

I have the following result set in sql server 2005. Column1 column2 column3 column4 cc cc1 cc2 cc3 dd dd1 dd2 dd3 Now I want to convert above result into the following table without using cursor in SQL Server 2005. column1 cc dd column2 cc1 dd1 column3 cc2 dd2 column4 cc3 dd3 Please help me.

[Mycroft Holmes]

Look into unpivot, I've never actually had to do this but pivot work fine so I assume unpivot will also.

Never underestimate the power of human stupidity RAH