CREATE PROCEDURE dbo.[Forum_Thread_StatusChange]
    @ThreadID INT,
    @UserID INT,
    @Status INT,
    @AnswerPostID INT
AS
    IF @Status = 2 -- 2 is resolved
        BEGIN
            UPDATE  dbo.Forum_Threads
            SET     ThreadStatus = @Status,
                    AnswerUserID = @UserID,
                    AnswerDate = GETDATE(),
                    AnswerPostID = @AnswerPostID
            WHERE   ThreadID = @ThreadID
        END
    ELSE
        BEGIN
            UPDATE  dbo.Forum_Threads
            SET     ThreadStatus = @Status,
                    AnswerUserID = -1,
                    AnswerDate = NULL,
                    AnswerPostID = -1
            WHERE   ThreadID = @ThreadID
        END

GO