Having written stored procedures for V8 (and below) for years, it's somewhat embarrassing that I'm stuck on this question:
Whereas V9 and above have the handy "SELECT FROM myProcedure()" syntax, V8 has not.
So, within a different stored procedure, when I have a stored procedure myProcedure that returns a result set and I want to insert the result set into a table (here a local temporary one), do I have to use a cursor loop in V8?
I.e. if MyProcedure returns a result set with column MyPk, is a cursor loop like the following the single approach:
Sidenote: T-SQL has the INSERT ... EXEC syntax for that but that doesn't seem to work with V8, and it would be infeasible here as I'm dealiung with a Watcom-SQL procedure (of course!).