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.
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:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required