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
Prevent overlapping of time events with an indexed view.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.