Hi Bonnie,
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.
>Thanks Sergey (and Borislav & Naomi). I guess I'll need to do the dynamic SQL if I want to implement this. =0(
>
>
>Can you post your actual query? Does it return a lot of records?>
>The query doesn't matter ... I can figure out how to make it dynamic, that's not hard. I just didn't want to do it if I didn't have to. Not quite as elegant of a solution. =0(
>
>But why do you ask if it returns a lot of records? Is there a performance hit executing dynamic SQL?
--sb--