> At 06:33 AM 12/21/2004, Vlad Horsun wrote:
> >
> > If SP has outputs - do SELECT else do EXECUTE. What is wrong with it ?
>
>
> A procedure can have output parameters and produce output
> without having a SUSPEND. Such a procedure returns results
> when called with EXECUTE and returns NO ROWS when called
> with SELECT.

This is develore's mistake - write procedure without SUSPEND
and call it with SELECT. This "problem" is like a "problem" with
FOR SELECT INTO when variable not change it's value if resultset
is empty

Regards,
Vlad