Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
inserting values of RFID and finding associated EMPID
Nazneen Sayed
Mar 8 2017 2:40 AM
313
Reply
Hi,
i am trying to bulid an Attendance system project and need a Query for inserting values into my dbTable which has two FIelds RFID and EmpID.
the RFID Field can be saved multiple times and need to find EmpID associated each time card is swaped.
so far i have tried :
INSERT INTO dbTable (RFID,EmpID) SELECT TagID,EmpID FROM EmpTable
i dont see any results though. the RFID which will be number of times must be saved at rumtime and i want associated EmpID next to it so that i can identify which user swapped card how many times.
any suggestions?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Stored Procedure to divide two columns and store the result
storing huge data