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?

@KonstantinV.Salikhov It's a remote database and PIVOT and UNPIVOT requires the compatibility level of the database to be changed. — SRK
– SRK, Commented Jul 2, 2014 at 6:31

TechDo · Accepted Answer · 2014-07-02 06:18:22Z

2

Try:

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

answered Jul 2, 2014 at 6:18

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1