I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table. I then have a correlated subquery that runs against the temp table. Now when I look at the ...