>Hi:
> I have a table and that table contains duplicate records. I want to copy all the duplicate records to a temp. file.
>
>SELECT Phon0701.ani, Phon0701.billdate, Phon0701.duedate,;
> Phon0701.totlocchrg, Phon0701.entrydate, Phon0701.entryby;
> FROM phon0701;
> WHERE Phon0701.vendor = '12182' and deleted() = .F.;
> ORDER BY Phon0701.ani;
> InTo cursor CmnthlyRpt
>
>How can I copy dup. rec. to a temp file? I try using set order to anii, but this did not work.
>Thanks
See the recent FAQ entry "Eliminating Duplicates" for some ideas. Do you want to put all records, which have duplicate, into temp file? What is the field, which tells, if the record is duplicate or not?
If it's not broken, fix it until it is.
My Blog