jgenovese (11/17/2012)
"One other thing would really help, the actual execution plan."This IS the ACTUAL execution plan
"Also, do you really drop the temporary table as soon as it is populated as it appears in the code you posted?"
NO -- I extracted the query from the stored proc in which it resides
As for this being an actual execution plan, no it isn't. All that is shown in the plan are estimates. If this were the actual execution plan there would be actual counts shown in addition to the the estimates.