>CREATE TRIGGER [dbo].[Transfers_Insert_AdjustItemQty] > ON [dbo].[transfers] > AFTER INSERT >AS >BEGIN > SET NOCOUNT ON; > > MERGE dbo.Items as Target > USING (select trn_itmfk as ItemId, SUM(trn_Qty) as TotalQty >FROM Inserted GROUP BY trn_itmfk) AS Source ON Target.ItemId = Source.ItemId > > WHEN Matched AND Target.ItemTypId = '43' THEN UPDATE > SET iQtyOnHand = iQtyOnHand - COALESCE(Source.TotalQty,0); > > >END > > >GO>
UPDATE dbo.Items SET Items.iqtyonhand = Items.iqtyonhand - Inserted.trn_qty FROM dbo.Items INNER JOIN Inserted ON Items.iItemid = Inserted.trn_itmfk WHERE iItemTypId = '43'Would that still have the same mistake?