querying a DB and returning Id's - HELP PLEASE

Discussion in 'ASP .Net' started by Mark, Jan 13, 2004.

  1. Mark

    Mark Guest

    I need help with the following please

    I am dealing with 2 DBs
    one local with full write access (can put an sp on it)
    and one faraway with ready only access

    I need the code to stick in a class that will do this

    For each BookingRef in LocalDb
    Select * from FarawayDB
    where FarawayDB.BookingRef = LocalDb.BookingRef
    Copy ID from farawayDB AND LocalDb into LocalDb.MatchedRecords
    next
    both DBs are on different serversI realise this may be the wrong way but it
    gives you can idea that i want to query a DB with bookingsrefs i store in my
    local DB, and copy them to a table if they match THanks Mark (newbie)
    Mark, Jan 13, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Marlon
    Replies:
    0
    Views:
    461
    Marlon
    Jul 22, 2004
  2. Marlon
    Replies:
    2
    Views:
    2,158
    Roger Bavaud
    Jul 22, 2004
  3. VJ
    Replies:
    4
    Views:
    437
    Dimitre Novatchev
    Nov 7, 2003
  4. KK
    Replies:
    2
    Views:
    550
    Big Brian
    Oct 14, 2003
  5. Marlon
    Replies:
    1
    Views:
    113
    Egbert Nierop \(MVP for IIS\)
    Jul 22, 2004
Loading...

Share This Page