determain if two date ranges in single table overlap sql code example
Example: check if two date ranges overlap sql server
(StartDate1 <= EndDate2) and (StartDate2 <= EndDate1)
(StartDate1 <= EndDate2) and (StartDate2 <= EndDate1)