Querying SQL server multiple times or in one go

[raiyanb]

Hi

I just wanted to know what the performance slowdown would be if I had a table of data (no more than 200 records) and I wanted to query each line against SQL server to pull back another field of data.

Would it be alot slower to open the connection and query one record by one record, or would it be ALOT better to group all the records together and pull back the data in one bigger query and then use Vlookup to join the results?

Thanks

 

[Norie]

1 query is bound to be quicker than 200 (approx).