You are right... RECURSION was used to solve the problem.

Still, i feel that updating thousands of rows in a single go can be easily done with XML and using database support for XML. And it is really helpful, when the details are scattered on different servers.

thnx.