Hi 🙂 regarding the time yes sometimes they do work straight due to work demand...

The Lunch break is fixed Lunch start at 12 and it ends at 1 but sometimes...

Hi sorry for confuse you about the question:

1. How can i get the Log In and Log out based on their official time (with shifting)?

2. How to to get the...

ChrisM@Work (10/4/2013)

---

--------------------------------------------------------------------------------

-- Modified sample dataset

--------------------------------------------------------------------------------

DROP TABLE EMPTMS

CREATE TABLE EMPTMS

(Uidfirstname varchar (50),

Uidlastname varchar(50),

Reader int,

dtdate datetime);

SET DATEFORMAT YMD

INSERT INTO EMPTMS (uidfirstname, uidlastname, reader, dtdate) VALUES

('001','Alvin','1','2013-09-20 6:30:000 '),

('001','Alvin','2','2013-09-20 17:50:000 '),

('001','Alvin','1','2013-09-21 6:30:000 '),

('001','Alvin','2','2013-09-21...

Hi the output should be...

yes sir..

So you have two readers which can record a stamp but you don't know if the stamp is for entry or exit, so the reader id is irrelevant?

Do you...

Hi wolfkillj sorry for confusing everyone. Our system has installed 2 readers at the Main door which everyone use punch as an access . thats is the reason why employee...

Sir 2005.

Hi wolfkillj thank you for helping me find solution to my problem.

i tried your script and it was ok, but i found something wrong. I tried to add 1 log...

Hi SSCertifiable thanks for the comment here is the query;

CREATE TABLE EMPTMS

(Uidfirstname varchar (50),

Uid1lastname varchar(50),

Reader int,

dtdate datetime

);

INSERT INTO EMPTMS

(uidfirstname,uidlastname,reader,dtdate)

VALUES ('001','Alvin','1','2013-09-20 6:30:000 ')

INSERT INTO EMPTMS

(uidfirstname,uidlastname,reader,dtdate)

VALUES ('001','Alvin','2','2013-09-20 17:50:000 ')

INSERT INTO...

Hi sqlnaive, thank you for your reply, but unfortunately thr script found some error. The NULL was filled with the wrong timeout or timein.

thanks

Hi SSC-Enthusiastic, thanks for your help, i tried your suggested script it was ok, unfortunately i encounter a problem. if an employee forgot to logout his/her wont come out to...

Hi Luis thanks for the reply, yes i dont have a column for the shifting schedule. would you mind to give me some script sample to get the correct output?

thank...