Trivially, but not in any way we can describe meaningfully based on your post. One way would be to store the starting date and calculate the salary based on time passed since the starting date. But your question as it stands is vague and meaningless. How do you WANT to increase it ? What have you tried ? What is your table structure ? What are the rules you want to impliment. Even if you can't be bothered trying to do this for yourself before asking for help, no-one can help you without more information.
Based on your comments, I think selecting your data in a cte and then treating it like a list you want to find islands in, will help.
[
^]
Is a great article on finding islands. I don't see how this relates to your original question.
[
^]
Covers selecting a range to a single string. What you want is a little crazy IMO. Your better off doing this in code.
Submit an article or tip