I have run these 2 update statements twice a week:
Update table1 set field4 =0 where field5 <25
Update table1 set field4 =field5-25 and field5>26
How can I automate these statements so that they run at a certain time every week and get a log feed back how many
records were effected.
I would really appreciate any tip.
Update table1 set field4 =0 where field5 <25
Update table1 set field4 =field5-25 and field5>26
How can I automate these statements so that they run at a certain time every week and get a log feed back how many
records were effected.
I would really appreciate any tip.