I have a report that uses several CTEs, each CTE return several values. One of the values returned from each CTE is actually one that I need to use as a column name in the final report. Please can you advise if there is a way assign the value to the column name e.g.
CTE1.Value AS CTE1.ColValue
Obviously wont work but in effect what I am trying to achieve.