Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

TSQL Challenge 49 - Identify overlapping time sheet entries of field t

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.

http://beyondrelational.com/blogs/tc/archive/2011/02/07/tsql-challenge-49-identify-overlapping-time-sheet-entries-of-field-technicians.aspx

 
Total article views: 1382 | Views in the last 30 days: 1
 
Related Articles
FORUM

Sum values from rows with overlapped dates

Overlap date range Sum

FORUM

Date Range overLaps

How to find date range overlaps

FORUM

Overlapping Date Ranges with Gaps Possible

Overlapping Date Ranges

FORUM

Grouping on Date Range / Overlap

Grouping on Date Range / Overlap

BLOG

Eliminate Overlapping Dates

I was looking for an efficient way to eliminate overlapping days when provided with a historical tab...

Tags
 
Contribute