Hi Everyone,

I found a 'solution' that works, but it's crummy I have to do this. I ended up bundling my SQL statements in to a variable and executing those variables at the end to make the report work. I guess if it doesn't find a valid Select it just executes it and runs with what comes back, which is what it should be doing from the start.

Still, any suggestions on how to avoid using Dynamic SQL to make this work? It's better then splitting the logic into multiple stored procedures, but still not what I hoped to do.

Thanks --

Sam Alex