>This also adresses SQL-queries on SQL server.

No it does not, since you did not use SQL-Server.......

>To my limited knowledge

This pretty much damages the credibility of your argument here...


>the strategy of SQL on a SQL-server is comparable with those of VFP. The intermediate results are also stored either in memory or on disk. I'm just pointing out that it would better to follow the described strategy in at least some cases.
>

You are basically saying that the VFP engine and the SQL-Server engine are on equal footing... This would be incorrect...


>Also note that my test seems to tell us that it less stresses the network, which indeed was an issue here. I've talked about redundant data send back by the SQL-server in end-users reports. If you'd look carefully this VFP approach would NOT have this problem because the data is combined at the client side and only downloaded from a remote site once.
>

This test tells us absolutely nothing that we already don't know, the fact that at times, in a VFP-only environment, X-base constructs can be more effective than SQL syntax...