Archives of the TeradataForum

Message Posted: Fri, 14 Dec 2012 @ 17:03:11 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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