If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Dynamic Record to column- PLEASE HELP

I need to create an SQL statement that will dynamically convert a row into a column. The main problem is that I do not know the name of the attributes or number of attributes at the time of running the query. This is because it dynamically changes based on metadata received.

All I want to do it convert say:

Name Address X Y Z
A B C D E

INTO

Name A
Address B
X C
Y D
Z E

Is this still possible with Pivots (if so how) or is there a better method?