This is the revised code.

I should clarify that we have join id column between schema1.table1 and schema1.table2 because it is a foreign key join . That is why we have...

Once again thank you for your Great Review. Ten Thumbs up!!!.

I hope this donut is not rolling down further.

"Divide'N'Conquer" code:

SELECT a.id as id, a.col1 AS col1, a.col2 AS col2

INTO #temp1

FROM...

Thank you for your feedback.

Actually the number of rows are more than 100 millions. I just put 100 millions as an example. Table schema1.table1 and schema.table2 has Primary Key and...

Better code:

SELECT  a.col1 AS col1, a.col2 AS col2, 
        b.col1 AS col3, b.col2 AS col4
INTO #temp1
FROM schema1.table1 AS a...

Thank you for your feedback and your time.

I suppose to write this code as below. and give more detail information about number of rows in schema1.table1 and schema1.table2. There about...

Thank you for your feedback. I will look into SYNONYM method. Have a great day.

Thank you, I got your point, It all depend on time to copy those tables. If they are less than 10 minutes, no need to do increment process, just straight...

The process suppose to run daily or weekly. I agree with you to process data using  SELECT [cols] WHERE ModifiedAt >= [last run date]. The reason i put this questions...

Thank you for your feedback, appreciate your valuable time, skills and know ledges. Do you agree if we have more than 5 millions rows in source table, we should start...