CREATE PROCEDURE dbo.[Forum_Forum_Delete]
    (
      @ForumID INT,
      @GroupID INT
    )
AS
    DECLARE @@SortOrder INT
    SET @@SortOrder = ( SELECT  SortOrder
                        FROM    dbo.Forum_Forums
                        WHERE   ForumID = @ForumID
                      )
    DELETE  dbo.Forum_Forums
    WHERE   ForumID = @ForumID
            AND GroupID = @GroupID

    UPDATE  dbo.Forum_Forums
    SET     SortOrder = ( SortOrder - 1 )
    WHERE   GroupID = @GroupID
            AND SortOrder > @@SortOrder

GO