I have the source table in Record number and tag number sequence.
EX. Rec# Tag Num Count
1 100 25
2 100 35
3 100 199
4 101 44
5 101 202
6 101 34
The table I want to update is
The table to be updated only had the tag number and the count number to be updated. I am getting the update to run in random sequence and I need it to run in the sequence of the source table. I want the ucount to be the count from the highest Rec# and the Tag# number that matches.
I wanted the results to be TagNum Ucount
How to I stop it from updating in a random sequence? I tried building the source in the sequence I wanted it to update the update table but got similar results. Any suggestions?