Hi,



I am having a bit of trouble with a project I am working on.

I have one ADO recordset that is retrieved via ADSI from Exchange Server,

and another retrieved from a SQL 7 dB. I need to return a 3rd recordset

which is a filtered comparison of the 2 existing recordsets i.e. users

that appear in the Exchange Server but not in the SQL dB.



Any ideas?



Many Thanks



Richard Falconer

This is probably pretty intensive, but OTOH you could insert the Exchange

server recordset into a temporary table and do a



SELECT ....

FROM SQLServerDatabaseTable

WHERE name NOT IN

    (SELECT ...

    FROM temptable

    )



and then this would contruct the second recordset that you refer to below,

by only selecting names that were in the main table, but not in the temp

table you just created.



Cheers

Ken





----- Original Message -----

From: "Richard Falconer" <richard_falconer@n...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, November 17, 2000 8:20 AM

Subject: [asp_databases] Compare results of 2 ADO recordsets





> Hi,

>

> I am having a bit of trouble with a project I am working on.

> I have one ADO recordset that is retrieved via ADSI from Exchange Server,

> and another retrieved from a SQL 7 dB. I need to return a 3rd recordset

> which is a filtered comparison of the 2 existing recordsets i.e. users

> that appear in the Exchange Server but not in the SQL dB.

>

> Any ideas?

>

> Many Thanks

>

> Richard Falconer