Hi Dragan

>Generally, the most expensive thing in SPT is the overhead of a single SqlExec (if we discount for bad database design, or other human factor issues). If your code needs to perform a lot of work on multiple records, get those records at once, and trust the Fox to do most of what you do (in case 1) in memory. The second case would require one trip to server for each record, which would create much more network traffic.

Thanks for your inputs. I have generally opted for the second option. Though given a bit of time I also want to try out the temp tables and SQLPREPARE() options.

Thanks.