RE: Duplicate records in PMP01

[Ram Hari <ramhari@xxxxxxxxxxxxxxx>]

Thanks Jeff,  I was confident that we would not have any, Guess what I found
3 parts/vendor combination that is duplicate.
I went ahead and took care of them.
Thanks again, 

Ram S. Hari
Sr. Programmer/Analyst
mailto:ramhari@wasserstrom.com
Voice 614.228.6525 Ext. 8542
Fax    253.484.5806 

 -----Original Message-----
From:   Jeff_Klipa/Harvard@harvardind.com
[mailto:Jeff_Klipa/Harvard@harvardind.com] 
Sent:   Friday, August 18, 2000 2:20 PM
To:     JBAUSERS-L@midrange.com
Subject:        RE: Duplicate records in PMP01

I just ran this little piece of SQL to see if we had any dupes and we have
only one part/vendor combination that is a dupe...  I don't know how it got
in there, but I deleted the one that was obviously not being used...

select cono01, vndr01, item01, count(*) from osld1f3/pmp01
group by cono01, vndr01, item01
having count(*) > 1

If you run this it will show you a listing of all of your dupes...  The
count value is the total number of records with that exact match as defined
in your 'group by' statement...

This might help you, I don't know...  Hope it helps...

Good luck.


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---