DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PROCEDURE TO IMPLEMENT FOLLOWING>>>

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    do it with a stored procedure or package.
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width