CREATE PROCEDURE dbo.[Forum_Group_Add]
    (
      @Name nvarchar(255),
      @PortalID int,
      @ModuleID int,
      @CreatedByUser int
    )
AS
    DECLARE @SortOrder int
    SET @SortOrder = ISNULL(( SELECT    MAX([SortOrder]) + 1
                              FROM      dbo.Forum_Groups
                              WHERE     PortalID = @PortalID
                                        AND ModuleID = @ModuleID
                            ), 0)    
    INSERT  INTO dbo.Forum_Groups
            (
              [Name],
              [PortalID],
              [ModuleID],
              [CreatedByUser],
              [SortOrder],
              [CreatedDate],
              [UpdatedDate],
              [UpdatedByUser]
          )
    VALUES  (
              @Name,
              @PortalID,
              @ModuleID,
              @CreatedByUser,
              @SortOrder,
              GetDate(),
              GetDate(),
              @CreatedByUser
          )    
    SELECT  SCOPE_IDENTITY()

GO