Posted by bobc on 10/02/07 14:35

> > I could call 20 different stored procedures, each having n SELECT
> > statements, but we all know a whole list of reasons why that's a bad
> > idea.
>
> Why would you have different procedures for different activities?

Thanks for your patience, Erland. In the statment above, I was
stepping through my thought process for you -- moving from the simple
method of executing many slightly different SELECTs, to a black box
solution that can handle all bins for all activities. The black box
is what I'm aiming for.

> Of course, this assumes that the data model is set, and neither that is
> clear to me. Then again, if you post what you have now, we may get a
> better grip of where you're heading.

The data model is set. I will rewrite my post today, providing the
information you've asked for.

Thanks again very much.

BobC

[Back to original message]