ALTER TRIGGER [dbo].[trMatcingStocksOnInsert]
ON [dbo].[order_details]
FOR INSERT 
AS
IF @@ROWCOUNT = 0
RETURN
SET NOCOUNT ON

DECLARE @g_id int ;
DECLARE @q int ;
SET @g_id = (SELECT 1 good_id FROM inserted)
SET @q = (SELECT 1 qty FROM inserted)
IF (@q)>0
BEGIN
UPDATE goods_stocks
SET stock = gs.stock - i.qty
FROM goods_stocks gs JOIN
(SELECT good_id, SUM(qty) qty FROM inserted GROUP BY good_id) i
ON gs.good_id = i.good_id
DELETE FROM goods_stocks
WHERE stock = 0;

END

ELSE IF(@q) < 0
BEGIN

INSERT  goods_stocks (good_id, stock, available) 
SELECT good_id,qty*-1,qty*-1
FROM inserted

END;