Home Forums SQL Server 2005 Development Converting sequential time records into IN and OUT times RE: Converting sequential time records into IN and OUT times

  • Hi Jeff,

    I do understand the fundamentals of your script. I understand your concern regarding employees who login in the afternoon and log out early the next day morning. We don't operate on a 24 hours basis and our stores close by around 9:00 - 9:30 PM in the normal course. On special days, when our staff are required to work late into the night, we will manually override the system hours. Since these are only 2 or 3 days in a year, we can handle this.

    Thank you for highlighting the point though. This just goes to prove that you are not just helpful, you are also very professional in your approach.

    Cheers

    Sudarshan.