to fix this you can use a query like this:
Code:
Delete tbAlternateNames
where idAlternateName in
(select Max(idAlternateName)
from tbAlternateNames
where isPreferredName = 1
and isShortName = 1
group
by idGeoName
,ISOLanguage
,isShortName
,isPreferredName
having Count(idAlternateName) > 1
)