Try
UPDATE tProducts
SET CurStockOnHand = CurStockOnHand + inserted.StockAdded - inserted.StockRemoved
FROM tProducts
JOIN inserted ON inserted.ProductID = tProducts.ProductID
>I have the following code in a trigger which updates a filed in another table. I would like to be able to do bulk inserts without using a cursor, but am not sure how to do this in this case. Any and all help is very appriciated.
>
>====================================================
>CREATE TRIGGER trUpdateCurrentStock ON dbo.tStockAvailable
>FOR INSERT
>AS
>
>DECLARE @ProductID INT,
> @StockAvailID INT,
> @CurrentStock INT
>
>SET @ProductID = (SELECT ProductID FROM INSERTED)
>SET @StockAvailID = (SELECT StockAvailID FROM INSERTED)
>
>SET @CurrentStock = (SELECT CurStockOnHand FROM tProducts
> WHERE ProductID = @ProductID) +
> (SELECT StockAdded FROM INSERTED) -
> (SELECT StockRemoved FROM INSERTED)
>
>UPDATE tProducts
> SET CurStockOnHand = @CurrentStock
> WHERE ProductID = @ProductID
>=====================================================
>
>P.S. - tProducts and tStockAvailable are related by ProductID.
--sb--