Hi David,
Check discussion starting from message #
1385177>Daniel,
>
>Use the Binary_CheckSum function. It can aggregate a value for all the columns you are comparing, it works pretty fast too. I had to put together a process that compared multimillion row tables to find the rows that needed updating.
>
>
>select Main.PK
> from Main
> inner join Secondary
> on Main.PK = Secondary.PK
> where binary_checksum( Main.ColA, Main.ColB, Main.ColC ... ) !=
> binary_checksum( Secondary.ColA, Secondary.ColB, Secondary.ColC ... )
>
>
>You can use left joins or exists checks to find the rows that need to be inserted.
>
>>I already have this done in Foxpro, scaning and comparing data in 2 tables, but is there a way
>>to do this in SQL Server using SQL???
>>Basically I have 2 tables that are identical in structure, but the data in one table may not be the same as the other, so I want to find out where the discrepancies are. Is this possible?
If it's not broken, fix it until it is.
My Blog