Hi Mike,

I am trying to do what you said concatenate all values to varbinary and then hash

when you say concatenate you mean add the binary value of each column as follows:

DECLARE @ColList Varchar(max), @SQLStatment VARCHAR(MAX)

SET @ColList = ''

select @ColList = @ColList + 'convert(varbinary(max), isnull(' + Name + ',0) )+ ' from syscolumns where id = object_id('aggregate')

SELECT @SQLStatment = 'SELECT ' + Substring(@ColList,1,len(@ColList)-1) + ' From aggregate'

select @SQLStatment

exec(@SQLStatment)