Re: Best way to compare records ?

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 24 Oct 2001 01:02:56 GMT
Message-ID: <Xns9143B79C6DA1DSunnySD@24.0.3.73>

"CrazyIvan" <crazyivan_at_pandora.be> wrote in news:XDWA7.18150$ic.1067_at_afrodite.telenet-ops.be:

> The problem is not getting it to work, but finding the most efficient
> method. At the moment i am
> fetching the new (master) records into a cursor. In the body of this
> cursor i locate the correposponding
> record (if any), wich i compare field by field using the NVL-function
> to avoid having to compare a value with a null-value.
> I find that this procedure works fine, but runs very slow.
> Maybe it's the only way?
>
> Thanx anyway..
>

Consider the following -
If you identify all the rows where the data matches exactly, then the remaining rows is where the data does not match! Received on Tue Oct 23 2001 - 20:02:56 CDT