Thank you so much!

That is exactly why I need to identify these contracts, the business rules were not put in place. This should never have happened and we need to fix these cases.

I think I figured out how to do it... using two temp tables. Let me know if there is an easier way please...

CREATE TABLE #Temp(

contract int,

ClientName varchar(100))

CREATE TABLE #Temp1(

contract int)

Insert...

This is not a homework assignment :-), I need to do this for my work but I am not very strong with the SQL. I tried group by and having...