TR_PDCOMPOSITESEGMENTMAPPING_IUD (Trigger)

        
        CREATE trigger dbo.TR_PDCOMPOSITESEGMENTMAPPING_IUD on dbo.PDCOMPOSITESEGMENTMAPPING
        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
          inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSYSTEM.ID = PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID
          inner join inserted on PDACCOUNTSTRUCTURE.ID = inserted.PDACCOUNTSTRUCTUREID
          where PDACCOUNTSYSTEM.DEFAULTGLACCOUNTID is not null
          and PDACCOUNTLOOKUPCACHE.ERRORNUMBER != 0
        else
          delete PDACCOUNTLOOKUPCACHE
          from dbo.PDACCOUNTLOOKUPCACHE inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
          inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSYSTEM.ID = PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID
          inner join deleted on PDACCOUNTSTRUCTURE.ID = deleted.PDACCOUNTSTRUCTUREID
        
         end