I have following query..
I get following data when i fire a query:
Now what i want to do is when i get this data then one by one i want to update the records one by one based on the values which i got above.
For e.g.After getting the above records i want to update some columns based on formula.The formula will be same for all these records.
Basically this are stock names & i want to update the stock moving AVG based on the condition.
Can this done in one query?
Thanks & Regards.