AnsweredAssumed Answered

Transpose Function Not Enough

Question asked by incentrik on Jul 29, 2016
Latest reply on Aug 1, 2016 by rene

I am creating attribute KPI's within PI_AF.  The KPI attributes (Max, Min, Weight) are sub-attributes to the parent attribute.  As you can see in the pic below the parent attributes are in there own columns.  I need to group the columns with the same parent.  See second pic. The first query is SQL commander and the second query is SSMS.  I cannot use the second query in SQL commander due to pivot and temp table creation.  How can I get the same results in SQL commander as I did in SSMS?  Thanks for any feedback.

Outcomes