I have a table in SQL Server named CustInfo that is as follows:
table CustInfo (
I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For example:
2008-01-01,2008-10-27,11,'13 Lexington st'
...meaning that I want to prohibit inserting any records between those dates for customer 11. However, I do not want to use stored procedures. Is there a way to do this?