>>>>Ducking issues again? Seriously, how can you justify 100's of round trips to the data base to "keep it clean and simple" vs 1 single call to get all data?
>>>
>>>Seriously, I do not call a round trip to the server a big hit. That's just the way it's done. My point was based on software maintenance, which is way more expensive than server hits.
>>
>>Round trip to the server is a hit. If you can do one SP that works with the list in one call (in SQL 2008 and up you better pass this table as TVP) then go for it and not for 100 individual calls. The performance is important.
>
>Naomi, I know performance is important. I didn't just fall off the turnip truck. It's just that the thought of a call with quote, hundreds or thousands, unquote of parameters makes me nervous.

But hundreds or thousands of trips to the server don't? Glad you don't write our data access...