A common table expression can include references to itself ... For more information, see the Remarks section and CREATE VIEW (Transact-SQL). If more than one CTE_query_definition is defined, the query ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...