Retrieving Uniqe records from a 2d Array

[ChuckG]

I have a VBScript that does a SQL call to a SQL database and retrieves records and stores them in aArray1. This is pulled using the DISTINCT keyword so only one entry for each part # is retrieved.

Then the same script does a 2nd SQL call to a different database, and does the same thing, pulls all DISTINCT records out into aArray2.

Then I'm combining the two array's into one Array (just laying all of Array2's info to the end of Array1.)

My question is, is there any way to look at the finished Array1 and determine if there are any part #'s in Column 0 that are duplicate.

I've been asked basicly if part # AAA exisits in both Array1 and Array2, they only want to see the part # from Array1.

Kind of stumped on this one, anyone have a suggestion?

Thanks
ChuckG

 

[PHV]

Why not using a single Dictionary object instead of 2 arrays ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886