Jump to content

I can't seem to figure out how to gather the found set I need...???


This topic is 6166 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a table called Auctions that has both an ItemNumber and a ScanID in it. ScanID's are unique to ItemNumber's, so if I have 10 auction records with the ScanID 12345 they should all have the same ItemNumber.

Somehow I've gotten lots of auction records that are getting incorrect ScanID's. I need to figure out how, but right now I simply need a way to find all of the problem records.

I can put a ! in the ScanID in Auctions to get a found set of records with duplicate ScanID's, however, I don't know what to do from there in order to filter so that I only see records with duplicate ScanID's but different ItemNumber's.

Any information would be greatly appreciated. Thanks!

Link to comment
Share on other sites

This topic is 6166 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.