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)