Daryl Smith (10/1/2008)
if exists(SELECT material_codeFROM MATERIAL_UPDATES
GROUP BY material_code
HAVING count(*) > 1)
BEGIN
select "Table has Duplicates"
RETURN
END
else
select "No Duplicates"
-- your query here
little nice stuff here ...!!! :hehe: