Increasing the price of an item by a percentage in all records
I have a product table which contains 50 records The table has 3 fields, Type, Name and Price.
I want to be able to increase the price of all the products by a certain percentage. Can anyone tell me the script steps I need to use so I can increase the price in a single action to all records.
When I tried to solve this problem by trying to increase all the prices by 10%, only the last record was updated, not all.
Any help appreciated.