update row always has results but still doesn't work

• Jason Wolfkill

  SSCrazy Eights

  Points: 9832

  More actions

  June 12, 2014 at 10:52 am

  #1721170

  pk2dpvp (6/11/2014)

  ---

  well,

  I fixed the problem

  though I do not know why it got fixed...

  what I did:

  I changed ever A to SP and every SP to A (Turned around the script so it'd run the other way)

  It made 1029 changes and afterwardsly no more then 0 unless I changed something

  So I changed it back again (Every SP to A and A to SP) and it just ran perfectly

  It still runs perfectly 😀

  I have no idea how that fixed it, But I'm glad it is fixed after all :p

  For now I guess this thread can be seen as [SOLVED]

  Thanks for the help, though! 😀 It is appreciated big time ^^

  I think you slipped this in somewhat offhand and we all missed it:

  pk2dpvp (6/11/2014)

  ---

  I'm still getting (2054 row(s) affected)

  That should change to 0 after running once, I have no idea why it doesn't just do that

  but whenever I change omschrijving or verkoopprijs it still doesn't notice it

  (I change the value's in the SparePartsUpdate table since that counts as "Dummy table" after ssis import)

  I have no idea how to fix this :p

  All it has to do is see if anything has changed between sp and a to update the sp data to the a table data

  If what you wanted to do was to make the values in the [sp] table match those in the [a] table, of course your UPDATE statement should start with "UPDATE sp" - the UPDATE runs against the table you want to change (the target) not the table that holds the new values (the source)!

  Jason Wolfkill