TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_IU (Trigger)

        
        create trigger [dbo].[TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_IU] on dbo.BANKACCOUNTTRANSACTION_EXT for INSERT, UPDATE not for replication as
        begin
          set nocount on;
          
            if exists(select BAT.ID from dbo.BANKACCOUNTTRANSACTION BAT
                          inner join INSERTED I 
                      on I.BANKACCOUNTID = BAT.BANKACCOUNTID 
                      and I.TRANSACTIONTYPECODE = BAT.TRANSACTIONTYPECODE 
                              and I.TRANSACTIONNUMBER = BAT.TRANSACTIONNUMBER 
                      and I.ID != BAT.ID
                          where BAT.DELETED = 0)
              begin
                  raiserror('UIX_BANKACCOUNTTRANSACTION_BANKACCOUNTID_TRANSACTIONTYPECODE_TRANSACTIONNUMBER', 16, 1);
            rollback transaction;
              end;
          
        end;