Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ucsutah
Starting Member
2 Posts |
 Posted - 2012-05-15 : 12:11:33
|
| I am new to sql, but i have to use it for my pricing updates. I am using this program here http://store-manager-for-magento-documentation.magneticone.com/products-management/import-products/expression-editorIn the editor it uses just regular sql statements as you can see. What i am trying to accomplish is at the price field, I would like it to query all pricing with the formula below. So if the cost price is .22 then the markup would be 9.5 = 2.09 and another example if the cost is 22.23 then the markup would be 2.0+3 = 47.46. How can i set this up with an sql statement? thanks 0 9.50.69 8.51 7.52 6.53 5.54 4.55 3.510 2.520 2+330 1.9+340 1.8+350 1.8+360 1.8+370 1.7+380 1.6+390 1.5+3 |
|
|
ucsutah
Starting Member
2 Posts |
Posted - 2012-05-17 : 00:13:04
|
| anybody have an idea how to do this? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Pricing Query Help