spDelete_Chapters

       CREATE procedure [dbo].[spDelete_Chapters]
        @PKID int,
        @ClientUsersID int,
        @ChapterSiteID int

        as

        IF @ChapterSiteID > 0 
            BEGIN
                DELETE ChapterRoles 
                FROM ChapterRoles cr inner join Chapters ch
                on cr.ChapterID = ch.id
                WHERE ch.ChapterSiteID = @ChapterSiteID 

                UPDATE EmailList
                SET Deleted = 1
                FROM EmailList el INNER JOIN Chapters ch
                on el.[ID] = ch.MemberEmailListID
                WHERE ch.ChapterSiteID = @ChapterSiteID

                DELETE PersonalPageData 
                FROM PersonalPageData ppd
                INNER JOIN Chapters ch on ppd.ParentID = ch.ID
                WHERE ch.ChapterSiteID = @ChapterSiteID AND ppd.ParentType=3

                DELETE dbo.Chapters WHERE ChapterSiteID = @ChapterSiteID

            END
        ELSE
            BEGIN
                DELETE ChapterRoles WHERE ChapterID = @PKID 

                UPDATE EmailList
                SET Deleted = 1
                FROM EmailList el inner join Chapters ch
                on el.[ID] = ch.MemberEmailListID
                WHERE ch.[ID] = @PKID

                DELETE PersonalPageData WHERE ParentID = @PKID and ParentType=3

                DELETE [dbo].[Chapters] WHERE [ID] = @PKID
              END