Transform rowvalue into columnheader 1

[onwagena]

I have a table with 2 columns:

Column1 Column2
----- ------------
Aa TextA
Bb TextB
Cc TextC

And I must transform this to an new table like this:

Aa Bb Cc
----- ----- -----
TextA TextB TextC

The values of column1 must be the columnheader in the new table

The select statement must be so dynamic that when there is a new record in the original table there must be a new column in the new table.

Aa Bb Cc Dd
----- ----- ----- ------
TextA TextB TextC TextD

How can I solve this problem?

 

[ousoonerjoe]

Take a look at PIVOT and UNPIVOT. Should get you started down the right path.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[markros]

Look at the Dynamic PIVOT. Here is a recent MSDN thread example:
MSDN thread in regards to Dynamic Pivot

PluralSight Learning Library