1. Home
  2. Point-Of-Sale Software
  3. Price Levels A and B

Price Levels A and B

Hi,

Can someone out there write a script or something to automatically update every item in our database to fill in Price Level A using the formula (Cost)

  • 1.18 = (Price Level A)?

and (Cost) * 1.25 = (Price Level B)

Thanks, George

Reply to
geokar
Loading thread data ...

hi, The said tasks can be accomplished using the store procedure and trigger. I have below the code for trigger however it is only for advanced users not begginer or intermediate. The same way you can make the store procedure, put as job and schedule it to run for every one hour. remember the resources and overhead for all this.

CREATE TRIGGER updPrices > Hi,

Reply to
Akber Alwani

Reply to
geokar

I think it would be UPDATE Item SET PriceA = Item.Cost * 1.18 Craig

Reply to
Craig

Reply to
geokar

Reply to
Akber Alwani

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.