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.