1. What does the execution plan look like? Do you see scans instead of seeks? Does the plan suggest indices? These could be performance factors.

2. the Order by clause is meaningless in a SELECT...INTO. You can remove it.

3. What should stop one operator from seeing another's results? It's not clear from the query.