Yes, this is probably the easiest way to build a table of duplicates.
Thanks.
Stan Loo
----- Original Message -----
From: "Ron Rose" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:05 PM
Subject: Re: Capturing Duplicates
> Now that you have the #'s of each duplicates, they can be expanded to
another
> table to exactly represent the original duplicates using declare cursor
and an
> IF...ENDIF loop.
> RRR
>
> > suredata wrote:
> >
> > Thank you Bill, Ron, Dennis, Phil, and Albert for responding.
Apparently I
> > did not make myself clear enough as to what I want.
> >
> > I need to save all duplicate rows to a new table or file, not just
knowing
> > which rows in the original table have one or more duplicates. In other
> > words, if a row in the original table has 5 duplicates (or 6 identical
rows
> > in the table), I want to save these five duplicates as separate rows in
a new
> > table. This new table would contain nothing but all duplicates in the
> > original table. Is there an easy way to achieve this?
> >
> > I hope this is clearer. Thanks again
> >
> > Stan Loo
>
