Can anyone give me the sql query to run to set lower bounds to cost + 5% for all items in the database? Looked for this in a previous thread and it seams that it was only when the item was updated.
- posted
15 years ago
Can anyone give me the sql query to run to set lower bounds to cost + 5% for all items in the database? Looked for this in a previous thread and it seams that it was only when the item was updated.
just run
Update item set PriceLowerBound = (cost * 1.05)
thats it.
ISSAM
"crossover" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.