Using a stored proc in a select statement

[Boucaner]

Howdy all,

in a new stored procedure, i want to so a 'select ID from table' to get all of the IDs in the table, and then run an existing SP for each ID. Seems simple enough, but then so am I.

Thanks

 

[JarlH]

Stored procedures is one of these areas where many dbms products are far from ANSI compliant. The ANSI term for stored procedures is Persistent Stored Modules (PSM), and were included in the standard in 1996.

You may "run" an existing PSM function(!) for each row in a SELECT result-set, e.g.:

SELECT somefunction(id) FROM sometable

 

[Boucaner]

i'll give it a try. thanks for the help!