CREATE PROCEDURE dbo.[Forum_Post_Reported_Add]
    (
      @PostID INT,
      @UserID INT,
      @Reason NTEXT
    )
AS
    DECLARE @@Count INT

    SET @@Count = ( SELECT  PostReported
                    FROM    dbo.Forum_Posts
                    WHERE   PostID = @PostID
                  )

    UPDATE  dbo.Forum_Posts
    SET     PostReported = @@Count + 1
    WHERE   PostID = @PostID

    INSERT  INTO dbo.Forum_Post_Reported ( PostID, UserID, Reason )
    VALUES  (
              @PostID,
              @UserID,
              @Reason
            )

GO