Those two tables are in the 3rd party database so I can't make any changes to them. The two queries that you thought were the same are actually based on two different parameters so I couldn't use a temp table. How do I swich off parallelism and what is it??!! Thanks Joe!!