CREATE PROCEDURE dbo.[Forum_Group_Delete]
    (
      @GroupID INT,
      @ModuleID INT
    )
AS
    DECLARE @@SortOrder INT
    SET @@SortOrder = ( SELECT  SortOrder
                        FROM    dbo.Forum_Groups
                        WHERE   GroupID = @GroupID
                      )
    DELETE  dbo.Forum_Groups
    WHERE   [GroupID] = @GroupID

    UPDATE  dbo.Forum_Groups
    SET     SortOrder = ( SortOrder - 1 )
    WHERE   ModuleID = @ModuleID
            AND SortOrder > @@SortOrder

GO