SQL: How to Insert INTO values from another table into another table
If you want to insert into a table value from another table or from CTE, make sure that you define columns to insert into a table then select * from cte/table. If you want to select into NEWTABLE from another table, there is no need to define columns to insert into.
+1 888-688-2939 
