Is it posible to update some fields X number of times.
Let say I have 100 rows each row have field qty and i want to update that field by -1 150 times total,
so i need procedure to go 1 time each row UPDATE qty = qty - 1, and second time to stop on 50th row
so i got total qty = qty - 150.
150 is variable, and also number of rows can be diferent.
I hope you guys understand what I want to acomplish.
P.S. Sorry for my english.
Let say I have 100 rows each row have field qty and i want to update that field by -1 150 times total,
so i need procedure to go 1 time each row UPDATE qty = qty - 1, and second time to stop on 50th row
so i got total qty = qty - 150.
150 is variable, and also number of rows can be diferent.
I hope you guys understand what I want to acomplish.
P.S. Sorry for my english.