Multi Pivoting on single Source data
        Posted  
        
            by Nev_Rahd
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Nev_Rahd
        
        
        
        Published on 2010-05-19T01:46:09Z
        Indexed on 
            2010/05/19
            1:50 UTC
        
        
        Read the original article
        Hit count: 323
        
I am trying to mutlipivot source data (as below )

want results as single column (as below)

My query so far is
SELECT  *
FROM    ( SELECT    *
      FROM      ( SELECT    NK,
                            DC,
                            VERSION,
                            GEV
                  FROM      MULTIPIVOT
                ) SRC PIVOT ( MAX(GEV) FOR DC IN ( [10], [11], [12], [18] ) ) AS PVT
    ) SRC PIVOT ( MAX([18]) FOR VERSION IN ( [2006], [2007], [2008],[2009] ) )AS PVT
which outputs results as

what is the way to get this as single row?
Thanks
© Stack Overflow or respective owner