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
Price Levels A and B
Aug 07, 2007
5 Replies
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,
I think it would be UPDATE Item SET PriceA = Item.Cost * 1.18 Craig
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required