TR_INSTALLMENT_INSERTUPDATE_CHECK (Trigger)

                
CREATE trigger TR_INSTALLMENT_INSERTUPDATE_CHECK on dbo.INSTALLMENT after insert, update
not for replication 
as 
  if exists(
    select * from 
      inserted
      inner join dbo.FINANCIALTRANSACTION as FT on inserted.REVENUEID = FT.ID
      where datediff(dd, FT.DATE, inserted.DATE)<0
    )
  raiserror ('CK_INSTALLMENT_STARTDATEVALID', 16, 1);