Please, read this:
SQL Server: SELECT INTO Statement[
^]
Quote:
If you find that you want to rename some of the columns within the new table rather than using the original names, you can alias the column names in the SELECT INTO statement.
For example:
SELECT employee_id AS contact_id, last_name, first_name
INTO contacts
FROM employees
WHERE employee_id < 1000;
In this SELECT INTO
example, we don't want the first column in the new contacts table to be called employee_id. It would be more meaningful to rename the first column in the contacts table to contact_id. This is done by aliasing the employee_id column as follows:
employee_id AS contact_id
SELECT TOP(100) [yyyy]
,[mm]
, NULL AS [cnt]
,[totaloutstanding]
,[outst30]
,[outst60]
,NULL AS [outst80]
,[outst90]
,[outst120]
,[outst150]
,[outst180]
,[outst210]
,[outst2100]
INTO [dbo].[irDataWIP]
FROM [LiveTest].[dbo].[irDataWIP_Prod19062019]