Just had an Idea! I think it should be simple:

The SELECT stored proc that I have selects all the records I need to update. So if I alter this proc...

I have to loop because I want to update the child's child's as well (and so on), so I have no common field (at least thats how my table is built...)

Do...

No, the select proc return multiple rows and I want to loop through them

and update each data at a time.

TNX