A great thing about Table Variables is that you can pass them as parameters to stored procedures, which gives a straight forward way to have procs do set based

A great thing about Table Variables is that you can pass them as parameters to stored procedures, which gives a straight forward way to have procs do set based operations, avoiding the need to call procs in a loop. I find this approach allows me to write smaller procs that become reusable in different contexts, effectively composable. Be careful that for over a thousand records table variables perform poorly, so I usually dump the data into a temp table inside the proc, or a permanent table with a key unique to this execution of the proc, this could be the SPID