General information
Category:
Coding, syntax & commands
Title:
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only