CREATE TRIGGER utr_Detalle_Insert >>ON Detalle >>FOR INSERT >>AS >>BEGIN >> INSERT INTO Balance (Cuenta, Periodo, Fiscal, Balance) >> SELECT Cuenta, Periodo, Fiscal, 0 FROM INSERTED >> WHERE NOT EXISTS( SELECT * FROM Balance >> WHERE Balance.Cuenta = INSERTED.Cuenta >> AND Balance.Periodo = INSERTED.Periodo >> AND Balance.Fiscal = INSERTED.Fiscal) >> >> UPDATE Balance >> SET Balance = Balance + INSERTED.Credito - INSERTED.Debito >> FROM Balance >> JOIN INSERTED ON Balance.Cuenta = INSERTED.Cuenta >> AND Balance.Periodo = INSERTED.Periodo >> AND Balance.Fiscal = INSERTED.Fiscal >> >>END >>GO >>