select *,row_number()over()
insert into table1
from location_table as lt