TR_FundRaisers_CASCDE_DEL_1

CREATE  TRIGGER TR_FundRaisers_CASCDE_DEL_1 ON dbo.FundRaisers
INSTEAD OF DELETE
AS
SET NOCOUNT ON
DECLARE @Count integer
Select @Count=Count(*) from deleted
if @Count>0
BEGIN

    DELETE FROM FundRaiserPages WHERE FundRaiserID IN (SELECT ID FROM deleted)

    DELETE FROM FundRaiserTeams WHERE FundRaiserID IN (SELECT ID FROM deleted)

    DELETE FROM FundRaiserSolicitors WHERE FundRaiserID IN (SELECT ID FROM deleted)

    DELETE FundraiserEmail WHERE FundRaisersID IN (SELECT [ID] FROM deleted)

    -- reissue the delete
    DELETE FROM FundRaisers
         WHERE ID IN 
        (SELECT ID FROM deleted)


END