I was able to modify the script above to have it select the "Distinct Top 1" and then assign that to a variable and insert that into the other scripts..

I...

Guess I should really classify that "yes", the product table and the c_funds table each have their own unique id that takes no NULLS.. The two id's FUNDID and ActualID...

Yes

They are both a string id of equal length.. both (varchar 64)

Sample from C_Funds:

Admin        2005-06-15 18:17:45.000 NULL 2005-06-15 18:17:45.000 123501863

Admin        2005-06-15 18:17:45.000 NULL 2005-06-15 18:17:45.000 123501866

Admin        2005-06-15 18:17:45.000 NULL 2005-06-15 18:17:45.000 123501869

Admin        2005-06-15 18:17:45.000 NULL 2005-06-15 18:17:45.000 123501872

Admin        2005-06-15 18:17:46.000 NULL 2005-06-15 18:17:46.000 123501881

Admin        2005-06-15...

no C_funds has FUNDID which is equal to Product ActualId

Vasc,

Those select Statements work correctly and I get 148 for the first and 50 i get for second..

The second matches the second statement...

Sorry Vasc, Didn't see the typo in my statements.. however even the change to FundId brings a zero return of rows that should at least be 1 but my guess...

Not exists also returns zero rows when I know there should eb at least one..

Vasc,

teh two select statements should be different one finds FUNDID in C_Funds not in Actualid in Product and the other finds actualid in Product not in fundid in C_FUNDS

You passed...