Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    23

    Unanswered: Problem writing Pseudocode

    How can I write a structured English Pseudocode for matching two – to extract matching data record from the table called “tblState” to update called tblCity. Below are the fields. I wan to extract NPI number from the tblState and update into tblCity. I am looking for Pseudocode for (a) matching, (b) validation, (c) update the record to tblCity table. Please really need somebody’s help.

    tblState
    NPI
    Org_Name
    Practice Address
    Zip
    State code
    Identifer ID
    Primary Taxanomy


    tblCity
    Org_Name
    Practice Address
    Zip
    State code
    Identifier_ID
    Primary Taxanomy

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    update tblcity
    set whatever to tblstate.npi
    join tblstate on tblstate.org_NAME = tblcity.org_name

    OR
    update tblcity
    set whatever to tblstate.npi
    WHERE TBLSTATE.ORG_NAME = TBLCITY.ORG_NAME
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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