Update Price A,B&C automatically when I change Regular Price

an auto change is possible only with database, or only with an add-on, but not with standard rms

cod

You could run this in SO Admin daily or after price changes:

UPDATE Item SET PriceA = Price * 1.1 UPDATE Item SET PriceB = Price * 1.2

I'm not sure how to set a trigger, but this is the SQL.

Maybe a developer would tell us how to make a trigger fire this SQL every time a price changes.

What you need is a database trigger. If you would like help figuring out the specifics please feel free to email me. We have done similar things for many customers in the past and this is a fast and easy solution to this type of problem.

Three ways-

1) Run sql statement from SA after every price change 2) Create a store procedure and run it on a scheduled basis - like every day 3) Create a trigger that will run automatically based on a database event... see ( ie: trigger could run after every new product insert and/or every product update) So which solution depends on if you would be changing many prices at once or other business rules that may apply ...like if you wanted to change all prices in category = xxxx to price = price *1.10 (10 % increase) , etc...

Dan

I have the same issue, except mine is a little more complex. Price A for items in department X is 5% off, but Price A for department Y is 10% off. The pricing wizard works fine for this, however it can be error prone, and sometimes I forget to do it for a couple of days, which ends up costing me $'s. If anyone has a good procedure for doing this I would like to hear it. Craig

hi ALL CHECK THIS i done for someone in newsgroup but the similar approach we can use: yes trigger is the best choice but noteout the procedure also, i done most of the jobs using procedure programming and schedule them.

CREATE TRIGGER updPrices ON Item FOR INSERT, UPDATE AS

-- IF (COLUMNS_UPDATED() & 2097152) > 0 IF UPDATE(CategoryID) UPDATE Item SET Price = ROUND(Item.Cost / .75, 2), -- 25% margin PriceA = ROUND(Item.Cost / .85, 2), -- 15% margin PriceB = ROUND(Item.Cost / .87, 2), -- 13% margin PriceC = ROUND(Item.Cost / .90, 2) -- 10% margin FROM Category,Inserted I WHERE I.CategoryID = Category.ID AND Category.Name = 'Airplane' AND I.ID=Item.ID GO

Or send your all requirement I will modify this per your needs. Rate me once it works for you.

Akber

"Craig" wrote:

Is it possible to do a query to get a list of all triggers set in a database?