Copy Code Trigger Definition 

        
          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);