TR_CONSTITUENTSOLICITCODE_TASYNC_U (Trigger)

        
    create trigger TR_CONSTITUENTSOLICITCODE_TASYNC_U on dbo.CONSTITUENTSOLICITCODE 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_CONSTITUENTSOLICITCODE t
        inner join INSERTED i on i.ID = t.ID
      end
    end