Home Forums SQL Server 2005 T-SQL (SS2K5) dupliate records RE: dupliate records
Daryl AZ
Hall of Fame
Points: 3087
More actions
October 1, 2008 at 5:13 pm
#879777
if exists(SELECT material_code
FROM MATERIAL_UPDATES
GROUP BY material_code
HAVING count(*) > 1)
BEGIN
select "Table has Duplicates"
RETURN
END
else
select "No Duplicates"
-- your query here