USP_DATALIST_CONSTITUENTUPDATEBATCH_RAISEEXCEPTIONFORAUTOMATCHES

CREATE procedure dbo.USP_DATALIST_CONSTITUENTUPDATEBATCH_RAISEEXCEPTIONFORAUTOMATCHES(
  @BATCHROWID uniqueidentifier,
  @AUTOMATCHRECORDID uniqueidentifier
)
as
    set nocount on;
      declare @DOMANUALREVIEWFORAUTOMATCH bit = 0;

      -- get rules settings from the batch row

      declare @NAMECODE tinyint;
      declare @SIMILARADDRESSCODE tinyint;
      declare @UNSIMILARADDRESSCODE tinyint;
      declare @DIFFERENTPHONECODE tinyint;
      declare @DIFFERENTEMAILCODE tinyint;

      select 
        @NAMECODE = NAMECODE,
        @SIMILARADDRESSCODE = SIMILARADDRESSCODE,
        @UNSIMILARADDRESSCODE = UNSIMILARADDRESSCODE,
        @DIFFERENTPHONECODE = DIFFERENTPHONECODE,
        @DIFFERENTEMAILCODE = DIFFERENTEMAILCODE
      from dbo.BATCHCONSTITUENTUPDATE
      where ID = @BATCHROWID;              

    exec dbo.USP_CONSTITUENTUPDATEBATCH_DOMANUALREVIEWFORAUTOMATCH @BATCHROWID, @AUTOMATCHRECORDID, @NAMECODE, @SIMILARADDRESSCODE, @UNSIMILARADDRESSCODE, @DIFFERENTPHONECODE, @DIFFERENTEMAILCODE, @DOMANUALREVIEWFORAUTOMATCH output;

    update dbo.BATCHCONSTITUENTUPDATE set 
      DOMANUALREVIEWFORAUTOMATCH = @DOMANUALREVIEWFORAUTOMATCH
    where ID = @BATCHROWID; 

      select @DOMANUALREVIEWFORAUTOMATCH as DOMANUALREVIEWFORAUTOMATCH