title: Get scalar value from SELECT statement in stored proc, from within a stored proc
body: <p>I know the preferred method for returning scalar values from stored procs is either using <code>RETURN</code> or an <code>OUTPUT</code> parameter. But lets say that I have a stored proc that returns the value using a select statement:</p>
  
  <pre><code>CREATE PROC spReturnNumber AS
  
  SELECT 1
  </code></pre>
  
  <p>Is it possible to get this value from within another stored proc?</p>
  
  <pre><code>CREATE PROC spCheckNumber AS
  
  EXEC spReturnNumber -- &lt;-- get the return value here?
  </code></pre>
  
  <p><strong>Clarification:</strong> I need a solution that doesn't require using an <code>OUTPUT</code> parameter, or using <code>RETURN</code> to return the value.</p>
  
  <p>Thanks in advance.</p>