One more help please.

I am getting invalid column name PKCol after Table 1 and Table 2 with the actual table names.

What is PKCol? is this the primary key...

Thank you for this. I will try

Jason Wong,

I have 2 tables. One is empty and the second table have over 20 millions rows. I want select rows from the table with millions rows and insert them...

I will do that.

Thanks Lynn,

Can you please explain this section of your code?

t1.*

from

dbo.JBMTest t1

...

Yes.