John,

>The question becomes what if you are doing this for a 10 row result set vs. a 1000 row result set? That is a good question. I would counter with how often, in a production C/S - n-tier app one gets a 1000 row result set.

What about generating data for reports (for example statistics) ? Seems quite common to me.

Walter,