Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: row level update and inserts

    =
    Last edited by babums; 09-12-03 at 15:34.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: row level update and inserts

    Originally posted by babums
    Hi,
    I need help.
    I have two tables A and B both of same structure and type.
    I need to insert all the records in A which are not in B(look by primary key). also if i found a match for record in table A with a record in B (based on PK) i need to copy the A record to B record. How can you do this by using cursors by row level updates and inserts..

    thanks in advance
    This can be done with only two pure SQL statements
    and no explicit cursors.
    Therefore I'm compelled to ask,
    which school, class & instructor assigned this trivial problem?
    It appears you were not pay attention in class or
    did not do your reading assignment.

    When all else fails, RTFM!

Posting Permissions

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