I need to have a AI ID column added when I do a:
SELECT * INTO newTable FROM(...
SQL SERVER we have
Is used only in a SELECT statement with an INTO table clause to insert an identity column into a new table. Although similar, the IDENTITY function is not the IDENTITY property that is used with CREATE TABLE and ALTER TABLE.
Try something like this
SELECT identity(int,1,1) as ID_Num,* INTO newTable FROM(...