mssql insert from a select statement but define fields manially code example
Example: myql insert from select
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;