How to call a stored procedure (with parameters) from another stored procedure without temp table

Question

I have stored procedure A and want to call store procedure B from A by passing a @mydate parameter. Stored procedure B will return a rowset which I can further use in procedure A.

I researched this on Google but did not find anything without using a temporary table. Is there an easy way to get this without a temp table.

P.S.: I tried to get this done using stored procedure as A and a function as B easily. But want to know if I can get it done only by using stored procedures.

Answer 1

 Create PROCEDURE  Stored_Procedure_Name_2   (   @param1 int = 5  ,   @param2 varchar(max),   @param3 varchar(max)   ) AS   DECLARE @Table TABLE (    /*TABLE DEFINITION*/    id int,    name varchar(max),    address varchar(max) )  INSERT INTO @Table  EXEC Stored_Procedure_Name_1 @param1 , @param2 = 'Raju' ,@param3 =@param3  SELECT id ,name ,address  FROM @Table