Hi,
This code is just an Example
Code:
update dbo.Employee set
    Salary = Salary * 1.2 -- Increase Salary by 20%
where
    Employeename = 'danial'
The salary of the Employee is 3000 per month till the month of June and then the salary is increased by 2000 and now the salary of the Employee is 5000 per month ,
and at end of the year , If I want to fetch the data of the employee ,how do I know from which date the Salary has been updated?
Till June 3000 per month
from June onwards 5000 per month
Is there a way to know that?