Why worry about the temporary extends if you're wanting to keep extending
them in the first place. Instead of having a permanent extension of 30 AND
a temp extension of 30 (that you have to constantly update), why not just
have a perm extension of 60 and leave the temp extension at zero. The temp
extension adds to the perm extension rather than overriding it (don't know
why).
update masteraccounts
set overdue = 60
where overdue < 60
>3) Where is the best place to run the scripts from?
ISQL/w
Josh