Hi Ronald,

I don't think you can solve this problem with SELECT-SQL statement (may be some really genious solution exists), but with the procedural code of looping through each employee and then each tasks per employee sounds like a pretty straightforward approach.

In other words, get the cursor of the Employees with Tasks for given date and then loop through this cursor for each employee and see times elapsed between tasks using some variables.

>Table with employee's starting time and ending time recorded for performing tasks.
>Times are recorded to the nearest 15 minutes such as 9:15 to 10:30 etc.
>
>An example would be employee scheduled for tasks from
> 8:00AM to 9:00AM (task 1)
> 9:30AM to 11:00AM (task 2)
>11:00AM to 12:30PM (task 3)
> 2:00PM to 3:00PM (task 4)
> 4:15PM to 6:00PM (task5)
>
>
>
>What is needed is to determine all thoes employee's who have a lapse of 15 minutes to 1.5 hours between tasks, so the above I would need to identify that the employee lapse of time of lapse time of 30 minutes from 9:00AM to 9:30AM (task2 to task 3) and lapse time of 1hr 15 minutes from 3:00PM to 4:15PM (task4 to task5)
>
>What is happening is that we are scheduling employees during the day and if we schedule less than 1 hour 30 minutes between tasks, we are required to compensate them for that time. If the lapse time is 1 hour 30 minutes or more, we are not required. Like wise if the lapse time is 0 (back to back) such as task 1 ending at 11:00AM and then task 2
>starting at 11:00AM M there is no lapse and therefore not required.
>
>Looking for the best solution to identify all employees on a give day that would fall into these lapse of times from 15 minutes to 1 hour 30 minutes.
>
>Thanks in advance for all suggestions.