problem discription:
i made a trigger (insted of update),an it works correctly, but if the updte statement matches more than one record an error appeared
ex: if i have products table,and i want to update the unitprice for the products which have Supplier id of 4 (ofcourse, many product my be supplied by one supplier).
all what i need from my trigger is: if the unit new price is less than the old one , the trigger puts the new in the audi table and rollback the transaction.
ANY ONE CAN HELP?????

Match for both SupplierID and the ProductID at the same time , because ProductID must be unique in the table