SQL Server – Table Variable Joins

I will admit that sometimes I have been known to use temporary tables rather than table variables, because of what I thought were limitations of the table variable. Turns out, table variables can do almost anything that a temporary table can do. Plus, they have the added bonus of having better performance, especially if they…