Hi everybody,
I'm wondering which best practice shall be adopted in the following scenario:
While looping through the records finding those to change, and calculating the two fields new values to modify, shall I go with UPDATE... SET... WHERE?
Or, shall I collect the records and do an UPDATE... FROM TABLE...? (in such a case, how many records shall I process? one shot?)
When to do a Commit Work?
Any suggestion on this is highly appreciated!
Thank you and Kind regards,
JFlanderds