• i'm presuming that the code in your EXISTS statement always brings back at least one row?

    it looks like, because it always brings back data, the EXISTS statement will always come back TRUE.

    so your basically saying:

    UPDATE Productss

    SET HotLeadParticipant=0

    WHERE

    1 = 1 --this will always be true

    that means your updating every record in your table..