We are trying to avoid opening the code, but it looks like we may have to.

I will check into the parameter sniffing - previously the query was dynamic - i could flip it back to that quickly to see if that actually increases the compile time.

Thank you for all input - if i have any great improvements i'll reply back.

🙂

donna