Thank this author by sharing:
By Jacob Sebastian,
TSQL Challenge 49 - Identify overlapping time sheet entries of field technicians
Several technicians are sent to a customer premises to do a certain maintenance work. Your task is to process the activity log entered by each technician and identify overlaps in the time sheet.
Overlap date range Sum
How to find date range overlaps
Overlapping Date Ranges
Grouping on Date Range / Overlap
I was looking for an efficient way to eliminate overlapping days when provided with a historical tab...