Mike,
thanks for your thoughts. Since these tables have fixed names I guess I will just have them created on the local temp dir. They will be overwritten each time the process runs. We started deleting old temp files years ago when hard drives were small and the temp folder would fill up if the PC crashed a lot. Just do an adir(aFiles) and erase any with the
aFiles(i,3) < (date() -2). We create our own temp dir on the root of c: so we don't mess up other running programs.

John

>Hi John
>
>AFAIK cursors are either in RAM or if necessary, written to temporary files. IMO when a PC does a SQLEXEC the data comes from SQL server to the PC's CPU and back to your server.
>
>In my most recent work, I found it much better for performance to have the TMPFILES on the local PC. This also eliminated possible collisions.
>
>I didn't think to get rid of two + day old files. I just tried to delete the ones I could without triggering an error.