Binary Checksum

• shirley.fernandez

  SSC Journeyman

  Points: 84

  More actions

  April 12, 2011 at 9:32 am

  #145487

  Can someone please explain why the checksum stays the same when I just move the decimal point of a number? If I check the number by an actual number that would change. We use this to calculate deltas and updates are not happening because the checksum is the same. Thank you much!

  SELECT

  binary_checksum(480.66) as checksum1;

  SELECT

  binary_checksum(4806.6) as checksum2;

  Both checksum1 and checksum2 return 381679841.

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  April 12, 2011 at 9:42 am

  #1310471

  Here is another thread that might shed some light.

  http://www.sqlservercentral.com/Forums/Topic342925-149-1.aspx#bm343219

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• shirley.fernandez

  SSC Journeyman

  Points: 84

  More actions

  April 12, 2011 at 9:52 am

  #1310480

  Thanks for the reply.