>>>>SELECT V.*,1 as DupType FROM csrVendors V ; >>>>INNER JOIN (select MIN(ID) as MinID, UPPER(full_name) as Full_Name FROM csrVendors GROUP BY 2 HAVING COUNT(*) > 1) Dups ; >>>>ON UPPER(V.full_name) = Dups.full_name AND V.ID > Dups.MinID ; >>>>UNION ; >>>>SELECT V.*, 2 as DupType FROM csrVendors V WHERE exists (SELECT full_name FROM i_vendor VV ; >>>>WHERE UPPER(VV.full_name) = UPPER(V.full_name)) ; >>>>INTO CURSOR csrVendorDups NOFILTER>>>>
>>>SELECT V.*, 2 as DupType; >>> FROM csrVendors V; >>>WHERE EXISTS (SELECT full_name; >>> FROM i_vendor VV ; >>> WHERE UPPER(VV.full_name) = UPPER(V.full_name)) ; >>>INTO CURSOR csrVendorDups NOFILTER >>>>>>
>>>SELECT V.*, 2 as DupType; >>> FROM csrVendors V; >>>WHERE EXISTS (SELECT full_name; >>> FROM i_vendor VV ; >>> WHERE VV.full_name = V.full_name) ; >>>INTO CURSOR csrVendorDups NOFILTER >>>>>>if you can.
>CREATE CURSOR csrVendors (Id I, Full_Name C(20)) >CREATE CURSOR i_vendor (Full_Name C(20)) > > >*SELECT V.*,1 as DupType; > FROM csrVendors V ; >INNER JOIN (select MIN(ID) as MinID,; > UPPER(full_name) as Full_Name; > FROM csrVendors; > GROUP BY 2; > HAVING COUNT(*) > 1) Dups ; > ON UPPER(V.full_name) = Dups.full_name AND V.ID > Dups.MinID ; >UNION ; > >SELECT V.*, 2 as DupType; > FROM csrVendors V; >WHERE EXISTS (SELECT full_name; > FROM i_vendor VV ; > WHERE VV.full_name = V.full_name) ; >INTO CURSOR csrVendorDups NOFILTER >BROW NORMAL > >SELECT V.*, 2 as DupType; > FROM csrVendors V; >WHERE EXISTS (SELECT full_name; > FROM i_vendor VV ; > WHERE UPPER(VV.full_name) = UPPER(V.full_name)) ; >INTO CURSOR csrVendorDups NOFILTER && BOOM :-) >>