Home Forums SQL Server 2014 Administration - SQL Server 2014 Displaying Multiple rows clock event Under a different Column view RE: Displaying Multiple rows clock event Under a different Column view

  • October 25, 2016 at 9:34 am

    #1908661

    would it make sense to calculate the overtime in a CASE statement eliminating the negatives before they get to your sum then? Something like:

    CASE WHEN Hoursworked > Dutyhours THEN Hoursworked-Dutyhours ELSE 0 END