-
Hi
The requirement is as follows...
Have a table for employees. As they join, they are under 'temporary' category for which employee id is 'temp01'. This employee has various details in some 25 other tables in the db.
Now, after 6 months, he is made permanent, so employee id is 'per01'.
Now, when i pass the old id 'temp01' and new id 'per01' to a procedure, it must gather the values from 'temp01' records of 25 tables and populate the 25 tables again, but for 'per01' record. It must also change the temp01 record to inactive (i.e., set/update a column 'status' to inactive).
Any ideas ?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|