I have found that table variables have their limitations.  In a datawarehouse environment, with query results totaling hundreds of thousands of rows, or more, table variables are NOT the way to go.  Temp tables work much better.

But.... thank you very much for the rest of the article.