Nadya,

You might consider keeping a checksum of the incoming addresses that you propose to correct on your live database. Then the next time it comes in, if the checksum in the live database matches the checksum on the incoming data, you know you've already dealt with this address historically.

Scott

>Hi everybody,
>
>I'm trying to find a solution for the following problem: Each year (or within other reasonable period) we receive data from Assessor. We then have to process these data and put into main database. One of the processes, we're doing, is street standardization. We usually receive unparsed address from Assessor and a special application then called and performs parsing and standardizing of addresses. (My application, BTW). So far, so good. Now, obviously property address is unlikely to change, so if we done some work with addresses in the previous year, there is no need to repeat this work next year unless it's a new property or something was wrong in the database...

<snip>