Home Forums SQL Server 7,2000 T-SQL How to calculate total working hours of all the employees in specified dates. RE: How to calculate total working hours of all the employees in specified dates.

  • The running time is because of the functions. You could put the function logic in the main query for better performance but you would be sacrificing readibility.

    The arithmic overflow error is because of the asumptions I made as I explained in my first post and happens at the 'InOffice' field. If you comment that out the query will run without error. But you would still have to fix the 'InOffice' calculation.