• This is the second article in a row that pushes the use of @tables.  There is little benefit if any, of using these instead of #tables.  In my experience @tables are alot harder to work with and dont work well with joins.  In the system I work with, I often need to modify existing code.  About half of the time I am up against @tables, the other half, #tables.  After struggling a few times, now my first step after I open the SP is to change all the @tables to #tables.  Just my opinion.

    If you want to jump on board with temp tables and leave variable tables out, the syntax is similar, only replace "Declare @myTable table(....)"  with "Create table #myTable(....)"