Set default time in SQL Server

• kevinphantsi

  SSC Rookie

  Points: 43

  More actions

  December 10, 2007 at 11:40 pm

  #181233

  [?]Hi guys

  I'm writing a Stored Procedure, on SQL Server 2005. I need to set a default time for the clock system, The clock in/out system works like this: When you clock in = 0, Clock Out = 1. So other employees they forget to clock out, we want to set a default time that when the employee didn't clock out then clock out time is 4:00PM.

  I've been struggling I don't know how to tackle it.

  Please help.

  Ndi

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 11, 2007 at 9:20 am

  #759025

  You could always iterate through your timesheet table at COB and update the records accordingly, i.e.

  UPDATE MyTimeSheetTable WITH(ROWLOCK)

  SET ClockOut = 1, MyDateColumn = CAST((CONVERT(varchar(10),getdate(),101) + ' 16:00:01') as datetime)

  FROM MyTimeSheetTable

  WHERE MyDateColumn IS NULL

  Not sure if I'm understanding all of your requirements. Hope this helps 🙂

  Tommy

  Follow @sqlscribe