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