CREATE TRIGGER trIngrOrderOnUPD
ON IngredientStocks
FOR UPDATE
AS
	BEGIN
		IF EXISTS
		(
		SELECT @igid=ISs.IngredientID, @uninst=ISs.UnitsInStock
			FROM IngredientStocks ISs
		WHERE ISs.IngredientID=inserted.IngredientID
		HAVING @uninst<=(SELECT ReorderLevel FROM Ingredients)
			BEGIN
				INSERT INTO IngredientOrders--([OrderID],[EmpID],[SupplierID],[OrderDate])
					VALUES (NEW.OrderID, NEW.EmpID, NEW.SupplierID, GETDATE())
			END
	END
GO