title: Is it possible to retrieve Selected Columns from Stored Procedure?
body: <p>I have a stored procedure which returns a few columns from a <code>SELECT</code>. Now I need to grab 2 columns out of those columns in my new stored procedure and use them.. I am trying to do this using EXEC method. Is it possible to do this?</p>
  
  <p>Ex : Original stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE myBaseProcedure
     @stId INT
  AS 
  BEGIN
   SELECT Name,
          Address,
          StudentId,
          Grade
   FROM Student
   WHERE StudentId = @stId    
  
  END
  </code></pre>
  
  <p>New stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE myNextProcedure
  BEGIN
      EXEC myBaseProcedure 19 -- Here I need to grab only StudentId and Name??
  END
  </code></pre>