How do I build a dynamic array from a SQL select statement

[Staj4]

Hey,
In our application, we need to build an array by selecting from a MS-SQL table.
We want to process as follows:

1) Load the array with the SQL select statement
2) Process the array item-by-item (loop)
3) Once a single item is processed, we want to delete the item from the array,
or at least never process that item again (in the process loop)

Can anyone please assist

Thanks
Scott

[janders468]

I assume from the wording you are using SQL server? What are you using for the front end?

[NeoPa]

Basic DAO recordset loop using two recordsets may prove helpful.

Welcome to TheScripts.