Unfortunately not, as that's the way the DB is set up. However, in testing, we find it is very fast doing it this way, and using temp tables seems to...

Thanks for the responses. I'll try to get the execution plans added as soon as I can

Thanks for the response. Normally, I'd agree, but we are seeing significant improvements working with temp tables (something I usually avoid like the plague). I think I have a solution...