title: How to call a stored procedure (with parameters) from another stored procedure without temp table
body: <p>I have stored procedure A and want to call store procedure B from A by passing a <code>@mydate</code> parameter. Stored procedure B will return a rowset which I can further use in procedure A. </p>
  
  <p>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>
  
  <p>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.</p>