Daryl Smith (10/1/2008)

---

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