>I was thinking about splitting your query into 2 steps. A regular query into a temp table and dynamic query from the temp table with calculated columns added. Ah ... good idea Sergey. And while I was reading your reply and thinking about it, my co-worker pointed me to something he had found which is similar, but even better (downside is that it still involves 2 selects):
http://www.sommarskog.se/dynamic_sql.html#columnaliasBasically it involves selecting into a temp table and then renaming the column(s) in the temp table and then selecting from it.
~~Bonnie