• 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