My previous post was how can i delete a record
from one table and insert the same record into another table
by checking the Status of a drug.
Apart from writing the insert, delete queries,
i wanted to have a timer and it should automatically update the
Status of drugs if the clock hits 12.00AM everyday otherwise at the time when i open my application.
Is it possible to implement this idea in MS SQL Server.
Pls do help me in implementing this idea even better.