Loop through table in chunks

CNH_1978 — Thu, 10 Mar 2022 15:54:43 GMT

Hi everyone.

I am trying to extract a table from our data warehouse with approx. 10 million records. It keeps timing out, so the DB team have suggested pulling the data in chucks instead of doing 1 single load.

Can anyone help in what I need to do to write a loop around my table load please?

The loop will just need to be on the number of records not on a date/month/year or any other field.

so i would extract the first 100,000 records, then loop to the start and extract records 100,001 to 200,001 etc, until all records have been extracted.

Thanks

Re: Loop through table in chunks

CNH_1978 — Fri, 11 Mar 2022 08:37:35 GMT

bump...

topic Re: Loop through table in chunks in App Development

Loop through table in chunks

Re: Loop through table in chunks