How to Pivot multiple columns into rows

Question

I am having a sample query data table:

I want my output table to look like:

I tried by using pivot operator but its not possible to sum them all.

The sample data and Output Sample data highlighted in blue are the links to the images of the respective tables — Saad, Jun 28 '16 at 09:38
http://stackoverflow.com/questions/38067490/in-sql-sever-how-to-pivot-for-multiple-columns .. same question been again asked !!!! — Malcolm, Jun 28 '16 at 09:40

score 0 · Answer 1 · edited Jul 22 '16 at 13:36

0

SELECT 
    * 
FROM
    (
        SELECT * FROM woddb.cityStock_Unpivot
    ) AS tblCity
    UNPIVOT
    (
        OutputValue FOR [OutputFieldName] IN (Sales, stock, [Target])
    ) AS UNPVT
    PIVOT
    (
        SUM(OutputValue)
        For Category IN (Panel,ac,ref)
    ) AS PVT

edited Jul 22 '16 at 13:36

Community

1
1

answered Jun 28 '16 at 10:35

ravi kumar

1

How to Pivot multiple columns into rows

1 Answers1