Sorry, my bad for not giving enough details. Here's the scenario - There are two tables, Parent and Child. When I run the update I can have two updates, one that updates the Status column of the Parent table, and a second that updates the same Status column on a single record in the Child table, where the ParentID is also stored. But what happens when there are two children for that parent? I need to be able to update ALL children of that same parent.