TR_PDACCOUNTCODEMAPPING_IUD (Trigger)

        
        CREATE trigger dbo.TR_PDACCOUNTCODEMAPPING_IUD on dbo.PDACCOUNTCODEMAPPING
        with execute as owner
        for insert, update, delete
        as
        begin
        set nocount on
        
        if (select count(*) from deleted) = 0   --insert

          delete PDACCOUNTLOOKUPCACHE
          from dbo.PDACCOUNTLOOKUPCACHE inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
          where PDACCOUNTSYSTEM.DEFAULTGLACCOUNTID is not null
          and PDACCOUNTSYSTEM.ID in (select PDACCOUNTSYSTEMID from inserted)
          and PDACCOUNTLOOKUPCACHE.ERRORNUMBER != 0
        else
          delete from dbo.PDACCOUNTLOOKUPCACHE
          where PDACCOUNTSYSTEMID in (select PDACCOUNTSYSTEMID from deleted)
        end