Subject Re: for select do - statement in nested SP
Author Ulrich
Alan,

> There is no return value for an SP unless you declare one. If you
> declare
> RETURNS, then you need a SUSPEND to return it.
> If you do not want a return, then don't declare it AND don't use
> SUSPEND.
> Alan

I wish you could see the smile on my face! It's working AND
everything is in only one SP AND no temporary table any longer! That
is, what was in my mind when I started do write the SP.

I thought, that SUSPEND must be in the <for select> loop to catch
every selected record, but I only need it when I have something what
I would like to give back with a return parameter....

Thanks - Ulrich