May be you can run this procedure overnight. Also you only need to run this procedure initially for all dates and put this information about compensations into some table with compensations per each date per employee. Then you would run this procedure only for the passed date.

Or you can run this procedure once a week on Saturday night, for example.


>Hoping for some suggestions since we are dealing with approx 1400 employees, 7 days a week and need to determine each week before payroll run which employee's need to be compensated for those lapse time less than 1.5 hours each day.
>
>I also have to go through the last years time records and identify each employee each day that would qualify. Quite tedious and was hoping for suggestiongs to accomplish. Of the approx 1400 time cards recieved for each day and tasks can be from 1 to over 12 per day per employee.
>
>
>>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.
>>