TR_FundraiserEmails_CASCDE_DEL_1

CREATE TRIGGER TR_FundraiserEmails_CASCDE_DEL_1
ON [dbo].FundraiserEmail
INSTEAD OF DELETE
AS
BEGIN
    DELETE FundraiserEmail 
    WHERE [ID] IN (SELECT [ID] FROM deleted)

    UPDATE EmailTemplate
    SET Deleted=1
    WHERE [ID] IN (SELECT EmailTemplateID FROM deleted)

END