Eric,

Always go for the technique that uses as little network bandwidth as possible. In this case, passing the SQL to the server is better than querying the entire dataset and then running a local SQL statement on it.

The only time that I can remember querying more data than necessary for the final result set is when the query combined data from two different servers.

- Keith

>I have a quick question. When generating reports do you A) just query for all the data and use local sql to process it, or B) just pass the sql directly to the sql server?
>
>I say this since I already download a copy of the main tables on startup.
>
>What would you do in this situation.
>
>
>Eric