My suggestion is go for Table variables when we know that the structure of the table is not going to change in future. Otherwise go for Temporary tables. Happy Reading

Read More