Include column names in the results of an unpivot query

Question

We have this UNPIVOT query.

SELECT Value
FROM (Your select statement) as x
UNPIVOT (Value FOR val IN (a, b, c, d)) as p

That produces results like this:

Value
value1
value2
value3
value4

How can we elaborate to include the column names?

Value     ColumnName
value1    a
value2    b
value3    c
value4    d

Select Value, vx from? – Giorgi Nakeuri Apr 22 '15 at 21:41 — Giorgi Nakeuri, Apr 22 '15 at 21:41
@downvoter Care to comment? – Shaun Luttin Apr 22 '15 at 21:44 — Shaun Luttin, Apr 22 '15 at 21:44

score -2 · Answer 1 · answered Apr 22 '15 at 21:43

-2

Thank you to Giorgi. Add val to the SELECT clause:

SELECT Value, val
FROM (Your select statement) as x
UNPIVOT (Value FOR val IN (a, b, c, d)) as p

answered Apr 22 '15 at 21:43

Shaun Luttin

1 Answers1