ALTER PROCEDURE [dbo]. [Hr_addnote2]
As
BEGIN
Update hr_1 Set remarks = ' normal 8 H ' where
Clock-in _a < CONVERT (Datetime,convert (char (10), DateTime, +) + ' 08:31:00 ', 101) and
Clock-out _p > CONVERT (Datetime,convert (char (10), DateTime, +) + ' 18:00:00 ', 101) and
Clock-out _a > CONVERT (Datetime,convert (char (10), DateTime, +) + ' 12:00:00 ', 101) and
Clock-out _a < CONVERT (Datetime,convert (char (10), DateTime, +) + ' 12:40:00 ', 101) and
Clock-in _p > CONVERT (Datetime,convert (char (10), DateTime, +) + ' 12:40:00 ', 101) and
Clock-in _p < CONVERT (Datetime,convert (char (10), DateTime, 120) + ' 13:31:00 ', 101)
And note is null and time attendance number not in
(select attendance number from Hr where department in (' Research and Development ', ' software department ', ' Human resources ', ' financial center ', ' Sourcing center ', ' marketing ', ' engineering Department ', ' head office ', ' general manager ', ' Sales company '))
END
-----assembly Punch-In
Worker Punch-In, normal execution data-get regular hours