Hi all. I am trying to access 2 tables from the same server (SQL Server 7.0)
but in different databases. I am trying to find the records in one table
that do not exist in the other. I am currently using ADO. But cannot figure
out how to compare the returned recordsets to see which records are NOT in
one set that exist in the other. CAn anyone please help. I am failry new
to VB and SQL Server although I know SQL and can write the SQL statements
that will perfrom this as a view or stored procedure.