#logo trigger

[sonerorhan]

Logo Sql Trigger ile Invoice tablosunda Trigger

– DROP TRIGGER dbo.tr_Invoice_SetTradingGrp CREATE TRIGGER tr_Invoice_SetTradingGrp ON [dbo].[LG_XXX_01_INVOICE] AFTER INSERT, UPDATE AS BEGIN UPDATE T SET T.TRADINGGRP = CASE I.SPECODE WHEN ‘GRUP_A’ THEN 1 WHEN ‘GRUP_B’ THEN 2 ELSE 0 END FROM [dbo].[LG_XXX_01_INVOICE] AS T INNER JOIN INSERTED AS I ON T.LOGICALREF = I.LOGICALREF END