Quote:
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.


This what i'd really like to be able to do. But not sure how to do it! Will have to have a play. I'm happy with restricting to first 3 or 4 chars if i can do it on the fly so no need for keys (and also means the mappings on the remote become irrelevant too)