I have a table in which I save a record each time when a user checks in and checks out the
office through a time in/ time out device(this device takes thumb impression of user, thus
table definition is as follows:
checkInOutID (PK,int,not null)
employeeID (FK, int, not null)
isCheckIn (bit, not null)
checkInOutTime (datetime, not null)
where ischeckIn is "true" if user checks in and "false" if user checks out.
if there are alternative checkin/check out records in the table then it means that there's
no suspect entry of user. but if there are any multiple consecutive records of check in or
check out, then all those entries will be considered to be suspicious.
PLEASE HELP ME IN MAKING A QUERY OR A STORED PROCEDURE TO RETRIEVE ALL THOSE SUSPECT
I will be extremely grateful!!