title: Check Return Value From Stored Procedure
body: <p>I have two stored procedures, ProcA and ProcB. I would like to ProcA to execute ProcB and have ProcB return an integer back to ProcA.</p>
  
  <p>My preference would be use a <code>RETURN</code> statement in ProcB, but I'll use an <code>OUTPUT</code> parameter if that's my only choice.</p>
  
  <p>Yes, there are similar questions on stackoverflow. But have yet to find a single one that will compile using Microsoft SQL Server 2008.</p>