CREATE PROCEDURE dbo.[Forum_AA_UserPostCountUpdate]
    (
      @UserID INT,
      @PortalID INT
    )
AS
    DECLARE @@PostCount INT
    
    SET @@PostCount = ( ( SELECT    PostCount
                          FROM      dbo.Forum_Users
                          WHERE     UserID = @UserID
                                    AND PortalID = @PortalID
                        ) + 1 )
    UPDATE  dbo.Forum_Users
    SET     PostCount = @@PostCount,
            LastActivity = GETDATE()
    WHERE   UserID = @UserID
            AND PortalID = @PortalID

GO