Hi every one
I would like to ask for the help, if possible.
I have bio-metric scanners which are feeding employees daily check in/out data to the DB "Att2000" into the "tblCheckInOut" which contained the following fields:
UserID - (Number)
CheckTime - (Date/Time) Format; 01/09/2009 13:15:31
CheckType - (Short Text)
VerifyCode - (Number)
SensorID - (Short Text)
I want to extract this check in/out time information to my EmDB where we have the TblEmployees including the fields EmpID, Name, Department, etc.
Note: The UserID and EmpID is the same as BatchNumber.
Kindly advise the procedure to extract this information to another intermediate table where to get check in and out information along all detailed information of the employee.