SELECT * from (stored procedure)

[Gina Onoyhac]

Hi all,


If I have a stored procedure returning a select result, for example:

CREATE PROCEDURE sp_test
BEGIN
   SELECT * FROM TestTable;
END

And in other stored procedure, I want to use the result, something like this:

CREATE PROCEDURE sp_test
BEGIN
   DECLARE MyVar bigint;
   SELECT Field1 INTO MyVar FROM sp_test;
END

Is making a code something like above possible?

Thanks in advance.