>>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.
If it's not broken, fix it until it is.
My Blog