New answers tagged auto-increment
I also agree with @James Anderson you would have to use SQL Agent for better result. If you don't know how to setup a SQL Job then, Please see this link for your reference how to set a SQL Job.
I don't think a cursor is good solution to this as it would have to be running 24 / 7 and you would need to check it was running. A better solution would be to have a SQL Agent job that runs at midnight each night. The Agent job would call a stored procedure that checks the IsActive flag, LastUpdate field and NextUpdate field for each employee and then ...
Top 50 recent answers are included