SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Increase all goods prices by a percentage ( 10%) (General)

posted by JayArr(R), Mission BC Canada, 12.02.2017, 23:53

This will round out the price if you like...


update parts

SET listprice = round((listprice*1.10)::numeric,2);

 

Complete thread:

Back to the forum
Board view  Mix view
963 Postings in 317 Threads, 321 registered users, 139 users online (0 registered, 139 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum