Using INSERT INTO with CTE

   

Source : https://database.guide/using-insert-into-with-a-cte-in-sql-server/