Thank this author by sharing:
By Jacob Sebastian, 2011/02/07
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.
http://beyondrelational.com/blogs/tc/archive/2011/02/07/tsql-challenge-49-identify-overlapping-time-sheet-entries-of-field-technicians.aspx
Overlap date range Sum
How to find date range overlaps
Overlapping Date Ranges
Grouping on Date Range / Overlap
Finding gaps in time when overlapping between intervals is allowed
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.
Join us!
Steve Jones Editor, SQLServerCentral.com
