Tag Info

New answers tagged

1

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.


1

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