ST012
Published 20 November 2017
Consider using temporary table instead of table variable
If you are doing more complex processing on temporary data or likely to use more than reasonably small amounts of data in them, then local temporary tables are likely to be a better choice than a table variable.
Available in
See Choosing Between Table Variables and Temporary Tables for more details.