Archives of the TeradataForum
Message Posted: Fri, 14 Dec 2012 @ 17:03:11 GMT
Subj: | | Using results returned from a Stored Procedure |
|
From: | | David Clough |
So, can I define a Stored Procedure to return to Return Result Set with 'DYNAMIC RESULT SETS 1' (of course I can) and then use that result set
in another invoking Stored Procedure ?
Yes, I know I could write the result set to a Global Temporary Table and then use that within the invoking Procedure, but I wondered whether
there was another way.
If so, does anyone know how to do it ?
Regards
David Clough
Senior BI Database Designer
|