Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[tg_CHANGES_SHIPPING] on [dbo].[SV_MACORD_FT_SHIP_AMT] FOR insert, update, delete as insert into dbo.Changes_Email (Record_SLOTID, ChangeDate, ChangeType) select IsNull(i.SLOTID, d.SLOTID), getdate(), case when i.SLOTID = d.SLOTID then 'U' when i.SLOTID is not null then 'I' else 'D' end from inserted i full outer join deleted d on i.SLOTID = d.SLOTID where FIN_AMT_TYPE_LGCY_CD = 'PHCG'