Excellent script very useful. I am looking forward to see the monitor script in a future article. Thanks.

All are excellent solutions. But the easiest one is to concatenate the two columns into a date field and do the math from there. Since the day is not important,...

Just a minor limitation about the CHECK Constraint. The date columns must not have NULLs in them. Otherwise, SQL will go and check both tables.

CHECK constraints reject values = FALSE....