spDelete_ChapterSite

CREATE  PROCEDURE [dbo].[spDelete_ChapterSite]
        @PKID int,
        @ClientUsersID int

        as
        --Clear out all emails associated with this chapter manager

        begin transaction

        exec spDelete_Chapters -1, @ClientUsersID, @PKID

        UPDATE EmailTemplate
        SET Deleted = 1
        FROM EmailTemplate et inner join ChapterEmail ce
            on et.ID = ce.EmailTemplateID 
        WHERE ChapterSiteID = @PKID

        UPDATE Email 
            SET deleted = 1
        FROM Email e inner join dbo.ChapterEmail ce
        on  e.EmailTemplateID = ce.EmailTemplateID 
        WHERE ce.ChapterSiteID = @PKID

        UPDATE ChapterEmail
            SET deleted = 1, UpdateDate = getutcdate()
        FROM dbo.ChapterEmail 
        WHERE ChapterSiteID = @PKID

        DELETE ChapterPages WHERE ChapterSiteID = @PKID

        DELETE FROM [dbo].[ChapterSite]
        WHERE [ID] = @PKID

        commit transaction