• As a rule of thumb I use table variables like scrap paper: Write a few lines, do not depend on it, use for a small set of data only.
    Say less then 10,000 rows of data, no real indexing needed, then a table variable will do the job just fine.

    Anything above that needs a proper bound notepad, ehm, temporary table. Might look a bit rough around the edges in naming scheme, just absolute necessary indexes only.
    And a table is like a book - properly bound with a good cover and back, has one or more indexes (whereas the book has indices) and much thought has gone into the naming (grammar rules).