SQL stored procedure IF EXISTS UPDATE ELSE INSERT ...

This is probably the problem right here: WHERE clockDate = GETDATE(). GetDate returns the current date ...

stackoverflow.com