USP_REVENUEBATCH_LOADCONSTITUENTEDITINFO_FOREXCEPTION

            create procedure dbo.USP_REVENUEBATCH_LOADCONSTITUENTEDITINFO_FOREXCEPTION(
        @ORIGINALBATCHROWID uniqueidentifier,
        @EXCEPTIONBATCHROWID uniqueidentifier
      ) as
      set nocount on

      select
        r.BATCHID,
        case when e.ID is not null then 1 else 0 end EDITINFOEXISTS,
        e.BATCHCONSTITUENTUPDATEADDRESSESID,
        e.BATCHCONSTITUENTUPDATEPHONESID,
        e.BATCHCONSTITUENTUPDATEEMAILADDRESSESID
      from dbo.BATCHREVENUE r
      left outer join dbo.BATCHREVENUECONSTITUENTEDITINFO e on e.ID = @ORIGINALBATCHROWID
      where r.ID = @EXCEPTIONBATCHROWID