Differ date update sql server

• Robert Dennyson

  SSC Veteran

  Points: 279

  More actions

  September 2, 2010 at 7:40 am

  #103979

  Hi guys,

  I have an issue with selecting data by date. In my case i have to update records for a particular employee, particular date based on the scheduled date.

  the base scenario is like that

  I should update the clockin and clockout information on a paticular date of an employee.If clock in happen today,

  but clockout happen tomorrow how can I display the data?

  Tables

  -------

  Employee{EmployeeID,EmployeeName}

  ClockIn{ClockInID,EmployeeID,ClockInDateTime}

  ClockOut{ClockOutID,EmployeeID,ClockOutDateTime}

  In this situation How can I fetch records by employeeId,date?

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 3, 2010 at 8:59 pm

  #1216483

  That's the question to the customer, not to this forum.

  There is no point to discuss an implementation if it's not clear how customer wants to see it.

  _____________
  Code for TallyGenerator