Hi,
Try this....
IF OBJECT_ID('OrderitemsInsertTRG') IS NOT NULL DROP TRIGGER OrderitemsInsertTRG
GO
CREATE TRIGGER OrderitemsInsertTRG
ON ORDERITEMS
FOR INSERT
AS
DECLARE @qty INT,
@Partid INT,
@Stockqty INT
BEGIN
SELECT @Partid = partid, @qty = qty
FROM INSERTED
UPDATE INVENTORY SET stockqty = stockqty - qty
WHERE partid = @Partid
END
Regards,
GVPrabu