At 06/25/2002 04:20 PM (Tuesday), Stevio wrote:

>However, I'm not familiar with SUSPEND. How does it work?

Stored procedures which return values can be used like virtual tables in
that you can SELECT from the stored procedure. Inside the stored procedure
you can perform one or more SELECTS and prepare output values based from
the results, looping over the result set of the internal SELECT. When you
do this you add a SUSPEND statement in the stored procedure to indicate the
output values are ready to be returned and that the server should suspend
processing of the stored procedure until the next "row" of values is
requested from the client's SELECT.