Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mlsrinivas
Starting Member
3 Posts |
 Posted - 2012-04-19 : 05:05:20
|
| Hello,I have a task on hand for which I do not have any clue to do it. Let me explain the scenario. We have employee records table, in which we store all the employee info along with monetary benefits. Once an employee gets hike the existing salary is updated with the new one. How to maintain a track of these changes. Now when the user picks up an employee and checks his salary for a particular month, we should be able to pick the salary in that month and not the current one.Even if we use triggers, I am not getting an idea how to retrieve data basing on the selected month.Any sort of lead/help is greatly appreciated. Thanks in anticipation.Srinivas |
|
|
|
|
|
Back tracking of data