• Another valid use case is of course as input parameter to a stored proc.

    Again, if i have a substantial amount of data in the table variable input parameter,

    I immediately move the data into an appropriately indexed # temp table.