Hello, this should be easy money for you if you know your database work. I have a table in a ms-sql database. This table has a column that takes readings with a time stamp called CHECKTIME. I want to create a trigger that will look into the previous entry and check the USERID, CHECKTIME, CHECKTYPE and SN, If the USERID and CHECKTYPE and SN are the same and CHECKTYPE is taken within 1 minute or less, it will not allow it to enter, it can be at the INSERT or after INSERT. The entries will happen at a fast rate, 2-10 seconds apart so your trigger should be ready to handle fast entries without causing issues to database.
Check the screenshot to know how the table is structured. It shouldn't take you more than 1hr maximum if you know your SQL.
Update: If the USERID and CHECKTYPE and SN are the same and CHECKTIME is taken within 1 minute or less, it should not allow it to enter in table
12 freelancers estão ofertando em média $28 para este trabalho
Hi there, i'm expert on SQL Server, actually i've done many trigger related to DML and DDL, pls also check my profile to see what i've done before. Thank you