Temporary Tables and Table Expressions

CTEs disappear the moment their statement finishes. Views stick around permanently. But sometimes you need intermediate results that last longer than a single statement without creating a permanent database object. That is what temporary tables are for.