philand3 (10/17/2016)

---

First Issue is:

my table dbo.test does not have any control on clock event(Clockin or Clocout) and table will accept whatever our Bio Metric machines throws the data. please note that our Bio metric machine has two button (IN button, Out Button).

First Event : Clock in (Button In)

Second Event : Clock in (Button In)

In above scenario first employee clock in and table get updated with clock in data and my SQL query shows

Same employee mistakenly pressing the "IN" button in bio metric machine and table will get updated but my SQL query should display "Duplicate In". example,

And it will be vice versa for Clockout and duplicate clockout.

Second issue should be solved in this same query,

Our biometric machine operates with badge(1) or numbers alias keyboard features.Employee can use badge or numbers for time attendance punches.scenario. person num 1019 s doing IN by using badge and query also shows .but it should disallow in query if they us keyboard features since person num 1019 does have not permission for the same but table is getting updated since table does not have any control.