Jeff Moden - Thursday, December 7, 2017 12:07 PM

s.ravisankar - Thursday, December 7, 2017 4:15 AM

Hi,

I have table x, table y

table x have millions of record, so i want to insert data by multiple batches into table y.

Since I have millions of record, batch size should be configurable and after insert it should close loop based on count in table x.

Thanks in advance🙂

Regards
Ravi

1.  How many "millions of record"?
2.  How many bytes does the average "record" contain?
3.  Are both tables in the same database, different databases on the same instance, different instances, or what ???