What is a good function to calculate the current hourly wage of an employee to a raise at a certain date?

Question

For example: Stewie is currently getting paid 12.50 an hour this month. By next month he will get paid 15.00 an hour. The way it'll calculate when to establish the raise, one must put the date that exceeds the previous month to the new month.
Any methods are appreciated.

Answer 1

I'm afraid I can't provide you any code, but an idea I have, maybe it goes like this:

Create a table for storing Stewie's id, and date when Stewie should get a raise

In anyway you can, create a schedule to check on the table and update Stewie's salary field in payroll table, when the date matches current date

For easier task I would suggest you to use stored procedures as they are centralized, easier to maintain

I hope I understood your point correctly, tell me if I didn't.

Hth, cmiiw