Subject Re: [firebird-support] SP join issue - (proper subject header this time - sorry)
Author Daniel Rail

At September 23, 2004, 08:10, Helen Borrie wrote:

> What's irrational is doing it by *joining* the output of different
> calls to the same SP using the same input parameters, causing
> millions of avoidable churnings and roilings.

If you read the parameters of both SP calls in the query, they are not
the same. If the query would always be comparing 2 periods, then it
would be possible to write a SP to retrieve the values of both SP
calls for both periods and join them in one returning row, instead of
trying to write a query that can take more time to complete.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (