Insert takes too long, code optimization needed

I\'ve some code I use to transfer a table1 values to another table2, they are sitting in different database.