Transpose multiple columns to rows

Asked Dec 08 '14 at 17:08

Active May 12 '16 at 15:55

Viewed 148 times

I have a following table :

  CREATE TABLE [dbo].[TestTranspose](
[ResultA] [int] NULL,
[ResultB] [int] NULL,
     ) ON [PRIMARY]

Whose result set is

     ResultA ResultB ... ResultZ

      1     10

      2     20

Desired result required is:

   Name       Compare1     Compare2

   ResultA      10            11

   ResultB      22            33
   ...
   ResultZ.

I know this needs to be done using STUFF to get all the columns and the use unpivot/pivot but just not able to get it working.

edited May 12 '16 at 15:55

madhead

asked Dec 08 '14 at 17:08

CodeHunter

and this is tagged mysql because...? – Strawberry Dec 08 '14 at 17:13
Your create table statement uses SQL Server syntax. You should tag the question appopriately. – Gordon Linoff Dec 08 '14 at 18:17
1

Possible duplicate of http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql – Duston Dec 08 '14 at 18:25

0 Answers0