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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-06-18 : 06:58:27
|
| I have a table and that stored employee information.If he exit from employment means, one column (current_status) will be 0, v r not physically deleting the employee's recordand after some time, the employee may rejoin, that time he is again added as new employee, but one flag is maintained is he rejoin employee or not and v have to store his prev.empid in one column.how to store his prev.emp.id to a column automatically when the emp. come to rejoin? |
|
|
|
|
|
storing emp.id automatically