18,158 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 10 mins ago

39s
answered Implementing application locks within SQL Server (Distributed Locking Pattern)
44m
reviewed Close Duplicate Entry Error with PHP When Trying UPDATE
49m
reviewed Approve suggested edit on Extracting the maximum of several subsets and join all maximums in a new table
2h
reviewed Reviewed difference between index REBUILD and REORGANIZE in relation to recompile in SQL Server 2008 R2
2h
reviewed Close It shows error in “WHERE pk.remarks = 'free'” can you give me any suggestion?
5h
reviewed Looks OK Matching two rows in a single table if two specific keys have different values
5h
revised Matching two rows in a single table if two specific keys have different values
added 53 characters in body
5h
reviewed Reviewed Merge/combine two queries with different dates
5h
revised Merge/combine two queries with different dates
added 228 characters in body; edited tags; edited title
6h
reviewed Reviewed MySQL crashes frequently on a Windows server
6h
reviewed Reviewed Query to join three tables
6h
revised Query to join three tables
formatting, title, tags
6h
reviewed Reviewed MySQL Dump failure in the middle
6h
reviewed Looks OK Query to join three tables
6h
revised Query to join three tables
formatted code
8h
reviewed Approve suggested edit on Update the other columns which are for to have minimum of other 2 columns , difference between 2 columns , and others
15h
reviewed No Action Needed Why is my select statement so slow?
15h
reviewed Close What are the advantages and disadvantages of Sequel Pro over writing on my terminal?
15h
reviewed Approve suggested edit on DB2 (LUW) equivalent for Oracle “drop user cascade”
1d
comment SQL Server - constraint to prevent overlapping dates
Your question seems to be asking how to prevent overlaps. The existing answer shows how to do this using DRI. It also links to an article that describes variations around allowing gaps or not. Seems the same to me, perhaps you need to clarify your question if indeed it is a different problem statement?