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
