Are you sure you cannot apply "more logic" in an UPDATE statement? Can you provide more details?
If you want to do record by record processing, you can (in no particular order)
- Use SQL Server cursors
- See Message #1217224
- See Message #1057625

>Ok, thanks, but I need to apply more logic. So, I need to select the records at first and loop. What adjustment would I need to do to support that?