Subject Re: [firebird-support] SP join issue - (proper subject header this time - sorry)
Author Gary Benade
> What about water-cooling the programmer? Why on earth would you want to
> do
> this? The mind boggles at the serpentine internals of it. Why not just
> write a single stored procedure to get the set?


Now that you have sufficiently humbled me, please explain the "serpentine
internals of it".
It works well with a join, why does an inner join break it?
The SP is very long and very complicated with one task only, to work out the
figures for the specified period. Why is it illogical to call the same SP
twice (or tens times) to get values for those periods?