Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > querying a DB and returning Id's - HELP PLEASE

Reply
Thread Tools

querying a DB and returning Id's - HELP PLEASE

 
 
Mark
Guest
Posts: n/a
 
      01-13-2004
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)


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Querying IISMimeMap .. Access is denied .. HELP! Marlon ASP .Net 2 07-22-2004 06:24 PM
Querying IISMimeMap .. Access is denied .. HELP! Marlon ASP General 1 07-22-2004 06:07 PM
Querying IISMimeMap .. Access is Denied .. HELP!! Marlon ASP .Net 0 07-22-2004 01:46 PM
Help with Querying XML Document VJ XML 4 11-07-2003 06:02 AM
please help... ...me learn C++ please please please :) KK C++ 2 10-14-2003 02:08 PM



Advertisments