title: Return multiple output from a stored procedure
body: <p>It it possible to return multiple output values to a parent stored procedure using </p>
  
  <p>exec 'stored procedure name' 'inputval','outval1','outval2'</p>
  
  <pre><code>exec sp_SubSalaryCalcuation @sec1_in,@sec1_out,@worktimefrm,@worktimeto,@out_timestatus OUTPUT,@out_status OUTPUT,@out_overtime OUTPUT
  </code></pre>
  
  <p>I need to call this stored procedure </p>
  
  <pre><code>ALTER PROCEDURE [dbo].[sp_SubSalaryCalcuation] 
  @out_overtime nvarchar(100) OUTPUT,
  @out_status nvarchar(100) OUTPUT,
  @out_overtimestatus nvarchar(100) OUTPUT,
  @sec1_in nvarchar(200),
  @sec1_out nvarchar(200),
  AS
  BEGIN
  SET @out_status=@sec1_in
  SET @out_overtime=0
  SET @out_overtimestatus=0
  
  END
  </code></pre>