TR_CONSTITUENTSITE_TASYNC_D

    CREATE trigger TR_CONSTITUENTSITE_TASYNC_D on dbo.CONSTITUENTSITE after delete not for replication
    as begin
      if dbo.UFN_B2T_CONTEXTISSYNC() = 1
        delete from dbo.TA_CONSTITUENTSITE
        where ID in(select ID from DELETED)
      else
      begin
        merge dbo.TA_CONSTITUENTSITE t
        using (select ID from DELETED) d
        on (d.ID = t.ID)
        when matched and t.ACTIONCODE = 1 then
          delete
        when matched then
          update set ACTIONCODE = 3;

        if @@ROWCOUNT < (select count(*) from DELETED)
        begin
            -- force re-sync of the parent row

          update dbo.TA_CONSTITUENT
          set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
          where ID in(select DELETED.CONSTITUENTID
                      from DELETED
                      inner join dbo.B2TROWS r on r.TATABLE = 'STATION_SUPPORT' and r.BBECTABLE = 'SITE' and r.BBECID = DELETED.SITEID);

          update dbo.TA_ACCOUNTS
          set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
          where ID in(select DELETED.CONSTITUENTID
                      from DELETED
                      inner join dbo.B2TROWS r on r.TATABLE = 'STATION_SUPPORT' and r.BBECTABLE = 'SITE' and r.BBECID = DELETED.SITEID);
        end
      end
    end