InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 11:23:49 GMT20http://www.sqlservercentral.com/Forums/Topic655437-1345-1.aspxI don't know why you make it in so complikated way.Below you can find my version of your procedure.[code]CREATE PROCEDURE [dbo].[ColumnDependency2] @TableName VARCHAR(128) , @Determinant VARCHAR(128) ,@Dependent VARCHAR(128) AS Declare @SQL VarChar(MAX);SELECT @SQL = 'WITH all_ AS ( SELECT '+@Determinant+' ,'+@Dependent+' ,count(*) cnt FROM '+@TableName+' GROUP BY '+@Determinant+' ,'+@Dependent+' ), fraction_ AS ( SELECT '+@Determinant+' ,max(cnt) support_count ,sum(cnt) frac_cnt FROM all_ GROUP BY '+@Determinant+' )SELECT v.'+@Determinant+' ,'+@Dependent+' ,cnt [Dependeny Counts] ,case when cnt &lt; support_count then ''Violation Percentage'' ELSE ''Support Percentage'' end [Dependency type] ,CAST(CAST(cnt AS DECIMAL ) / frac_cnt * 100 AS DECIMAL (5, 2)) AS PercentViolationFROM all_ v ,fraction_WHERE fraction_.'+@Determinant+' = v.'+@Determinant+'ORDER BY 1, 3 DESC ';Print @SQLExec (@SQL)[/code]and execution:[code]Exec ColumnDependency2 @TableName = 'Addresses', @Dependent = 'StateProvinceName', @Determinant = 'CountryRegionCode '[/code];)Sat, 14 Feb 2009 05:08:08 GMTtomasz.cwajdahttp://www.sqlservercentral.com/Forums/Topic655437-1345-1.aspxI really don't know what is showig this pie chart !This is some creasy idea to use pie chart to this data, is't it?Sat, 14 Feb 2009 04:51:46 GMTtomasz.cwajdahttp://www.sqlservercentral.com/Forums/Topic655437-1345-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Data+Profiling/65615/">Data Profilng Column Functional Dependency T-SQL</A>[/B]Thu, 12 Feb 2009 00:21:39 GMTIra Warren Whiteside