TR_CONSTITUENTAPPEAL_TASYNC_U

    CREATE trigger TR_CONSTITUENTAPPEAL_TASYNC_U on dbo.CONSTITUENTAPPEAL after update not for replication
    as begin
      if dbo.UFN_B2T_CONTEXTISSYNC() = 0
      begin
        update t
        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
        from dbo.TA_CONSTITUENTAPPEAL t
        inner join INSERTED i on i.ID = t.ID
      end
    end