All,

Need ideas on how to approach this:

Have to compare account numbers in one table to account numbers in another table and if they exist in the second table

The problem is the tables are in two separate databases (two different physical places). One table in the ERP system and the other is in the financial system.

table1 ERP system
table2 Financial system

1. Should I dump table 1 into dataset table, do the same with table two. This way they are both in the same dataset then figure out how to compare 1 to 2?

2. Do I dump table 1 into an array and iterate through the array making sql calls (using a data reader) to see if the account numbers exist in second table?

3. Put both tables in the arrays and hack away?

What do you consider a good approach or best practice?
Thanks in advance
RC

Not sure if you are using SQL server for DB. If so you can still use a join to achieve that. If those are on different systems, then you can still link the servers and use join.

_________________________
- Vijay G
Strive for Perfection

Never linked two servers together before. Which topics should I research

Simplest way I can think of is to use two seperate datatables, compare the two and work from there on out.

 I want to basic difference for foll. Que
  What is the difference between asp & asp.net?
  What is the difference between sql server 2000 & mysql?.