Re: DML Needed: Flag Duplicate Records....

From: R Chin <rchin_at_panix.com>
Date: Mon, 6 May 2002 16:47:36 -0400
Message-ID: <ab6q1e$lh7$1@reader1.panix.com>

Thanks, Sybrand,
But this is a dev issue...
I am loading data from outside, the feed is full of crap, I have several "filters" to cleanse them out....one of them being removing dupes before the next process...

Now user want to see the data BEFORE the scrub, so I have to flag them and make note of.

I should have saved the SQL to do this when I saw it before.... rob

Sybrand Bakker wrote in message ...
No
>You just need to set up a primary or unique key with an exceptions
>table associated to it, and that is it.
>But I have the strange feeling you are dealing with a self-grown mess
>and you should better stop symptom-fighting asap.
>
>Regards
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Received on Mon May 06 2002 - 15:47:36 CDT