Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check.
Ars Technica

Correlated Subquery MUCH slower than same query using temp tables: Not enough RAM?

I wrote a query (with lots of help, see my painfully plentiful other threads) using a correlated subquery and it takes 5.78 ...