• Joe Torre - Thursday, December 7, 2017 9:30 AM

    Use SSIS. It will handle inserts in batches behind the scenes without having to roll your own solution. You can do it manually using ORDER BY with OFFSET.

    +1