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.