Maximum limit for an array variable in progress.

What about it?

Functionally, you are limited by memory, which depends on what it is an array of.

If you want it functionally open-ended, then use a temp-table.