🚀 go-pugleaf

All,

  Let's say I have a very simple stored procedure:

  CREATE PROCEDURE UpdateByParentID (
    AValue integer,
    AParentID integer)
  AS BEGIN
    UPDATE SomeTable SET SomeColumn = :AValue WHERE ParentID = :AParentID;
  END;

...and I want to call it with a number of ParentIDs derived from a result 
set.  Something like:

  EXECUTE PROCEDURE
    UpdateByParentID (1, 'SELECT ParentID FROM SomeOtherTable WHERE 
SomeOtherID BETWEEN 1 AND 10')

or

  EXECUTE PROCEDURE
    UpdateByParentID (1, 'SELECT ParentID FROM SomeOtherTable WHERE 
SomeOtherCost BETWEEN 50 AND 200')

or...

  Well, you get the idea.  The query that generates the list of ParentIDs, 
can be as simple or complicated as I would like.  Is there a way to pass a 
result set as a parameter? There may be hundreds or thousands of ParentIDs 
that need to be passed.

  Any help would be appreciated.

Thanks!

-ed