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