• Neat article. I used it to automate a check for duplicates.

    CREATE PROCEDURE DBO.SP_DUPLICATE_CHECK

    @TABLE NVARCHAR(255),

    @CLM NVARCHAR(255)

    AS

    BEGIN

    DECLARE @CMD NVARCHAR(255)

    SET @CMD =

    'SELECT ' +

    @CLM +

    ',COUNT(*) AS CNT' +

    ' FROM ' + @TABLE +

    ' GROUP BY ' + @CLM +

    ' HAVING COUNT(*) > 1'

    EXEC SP_EXECUTESQL @CMD

    END

    GO

    EXEC DBO.SP_DUPLICATE_CHECK 'TABLE_NAME','COLUMN1, COLUMN2, ETC.'