What is it? A CTE Creates a temporary named result set. It is available within the execution of a single DML statement. A Common Table Expression can be used to:
1. Create Recursive Query
2. Create a temporary view, to simplify another query
3. To avoid “Msg 164, Level 15, State 1” &n......