declare @StartNumber int = 1000

insert into Table2 select (ROW_NUMBER() OVER(ORDER BY [field]  DESC)) + @StartNumber AS id, * from Table1

http://snipplr.com/login/

This code allows you to create an ID field value for inserts into a table that does not auto increment itself

Auto Incremementing Id for Insert in T-SQL table

sql

SQL