title: Returning multiple values from a stored procedure
body: <p>I am using SQL Server. I am calling a stored procedure from another stored procedure. </p>
  
  <p>I want to return multiple values from the first stored procedure. </p>
  
  <p>Ex: I am calling <code>Sub_SP</code> from <code>Master_SP</code>. <code>Sub_SP</code> will return multiple values to <code>Master_SP</code>. </p>
  
  <p>Can anyone give an example with OUTPUT parameters?</p>
  
  <p>Thank you.</p>