Rick Debay wrote:

>
> If the results from a selectable stored procedure are ordered, then all
> results are retrieved from the procedure before the first result can be
> processed. If the results are not ordered, then the first result will
> be available after the selectable SP executes SUSPEND.
>

Yes, that's right.

Ordering the result set requires producing all the results and
sorting them. If you don't know what the data is, how exactly are
you supposed to find the smallest or largest?


Regards,


Ann