Tools › CTE vs #temp

CTE vs temporary table selector

A CTE is a name for this statement. A #temp can be indexed and reused in the batch. Four questions.

Will you use the result more than once in the batch? Rough rows in the intermediate set Need an index or stats on that set? Recursion (walk a manager tree)?

Related: temp tables, CTEs.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.

Clock in free