Hi, I know this kind of a question is asked earlier, but I couldn't find an answer there (in the previous round of posting).
Instead of wanting to update the first record in an UPDATE .. ORDER BY condition, (because of triggers that act downward) what I want is that all records be updated, but in a given order, for e.g. ascending on date. Is a FOR LOOP my best bet or is something like UPDATE .... ORDER BY in the offing ? Thanks *Robins*
