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 '...