Quote:
a good tradeoff between hitting the database


The other thing which occurs to me: You can do this in SQL Server, but I don't know if it's exposed via OLEDB. You can send all 27 queries to the server as a single batch, and you'll get back 27 resultsets in the same response, thus saving a bunch of DB round-trips.
_________________________
-- roger