How to Display Columns as Rows in SQL Server

Question

I've a result set in SQL Server as follows:

PM    SPM   QA
714   NULL  NULL

I want to get a Result Set as follows:

Members
714 
NULL    
NULL

How to do This?

possible duplicate of [Unpivot with column name](http://stackoverflow.com/questions/19055902/unpivot-with-column-name) — Konstantin V. Salikhov, Jul 02 '14 at 06:16
@KonstantinV.Salikhov It's a remote database and PIVOT and UNPIVOT requires the compatibility level of the database to be changed. — SRK, Jul 02 '14 at 06:31

score 2 · Accepted Answer · answered Jul 02 '14 at 06:18

2

Try:

select PM Members From tbl
union all
select SPM From tbl
union all
select QA From tbl

answered Jul 02 '14 at 06:18

TechDo

1 Answers1