>>I'll give these two a try. Thanks again. Any other/further suggestions are greatly appreciated.
Christian,
It may not be related at all, but when creating multiple selects in a loop, it might be wise to clean them up afterwards with a USE IN selectalias before moving to the next one, or if your selects are causing a table with disk presence, to close and delete the file before doing the next one.
If you do get it solved, please report back so everyone will know what the problem was.