Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Updating groups of similar records
I have a table that looks similar to this:
prempl txqtr taxid qtax qbase qwage ytax ybase ywage ...
50000___1__futa__0.0__0.0___0.0__1.0___1.0___1.0
50000___1__suta__0.0__0.0___0.0__1.0___1.0___1.0
50000___1__fica__0.0__0.0___0.0__1.0___1.0___1.0
50000___2__futa__0.0__0.0___0.0__1.0___1.0___1.0
50000___2__suta__0.0__0.0___0.0__1.0___1.0___1.0
50000___2__fica__0.0__0.0___0.0__1.0___1.0___1.0
50001___1__futa__1.0__1.0___1.0__1.0___1.0___1.0
50001___1__suta__1.0__1.0___1.0__1.0___1.0___1.0
50001___1__fica__1.0__1.0___1.0__1.0___1.0___1.0
50001___2__futa__1.0__1.0___1.0__1.0___1.0___1.0
50001___2__suta__1.0__1.0___1.0__1.0___1.0___1.0
50001___2__fica__1.0__1.0___1.0__1.0___1.0___1.0
50002___1__futa__0.0__0.0___0.0__1.0___1.0___1.0
50002___1__suta__0.0__0.0___0.0__1.0___1.0___1.0
50002___1__fica__0.0__0.0___0.0__1.0___1.0___1.0
50002___2__futa__1.0__1.0___1.0__1.0___1.0___1.0
50002___2__suta__1.0__1.0___1.0__1.0___1.0___1.0
50002___2__fica__1.0__1.0___1.0__1.0___1.0___1.0
I want to update the ytd fields for only the employees with zeros in the qtax, qbase, and qwage fields for all the records for a given employee. If there is anything greater than zero in any record for a given employee, I want to leave that employee alone. I know I need to read all the records and figure out which employees have all zeros in those fields in every record for that employee, and then skip back to those records to update them. How can I do this?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement