OK, that's great, thanks.
I'll create sample data. You gave me general row counts before, so I will see what I can do to generate test data with those rows counts.
Ideally, I'd like to do two examples -
the first will use the same two queries that you have for RES1 and RES2, and then I'll write the data munging in ADO.NET. This will demonstrate how ADO.NET can be used. After I get some sample data loaded, I'll time the two processes [VFP and .NET].
The second example will try to put more of the data summarization into a stored procedure, with limited munging.
This will take some time, as I'm working on other things, but I'll certainly have this done before the end of the month, if not before.
Thanks for posting the code, I appreciate it. I'll try to limit my questions, but I may have a few as I go through this.
Kevin