CREATE PROCEDURE dbo.[Forum_ThreadRating_Add]
    (
      @ThreadID INT,
      @UserID INT,
      @Rate DECIMAL(4,2)
    )
AS
    IF EXISTS ( SELECT  ThreadID
                FROM    dbo.Forum_ThreadRating
                WHERE   UserID = @UserID
                        AND ThreadID = @ThreadID )
        BEGIN
            UPDATE  dbo.Forum_ThreadRating
            SET     Rate = @Rate
            WHERE   UserID = @UserID
                    AND ThreadID = @ThreadID
        END
    ELSE
        BEGIN
            INSERT  INTO dbo.Forum_ThreadRating ( UserID, ThreadID, Rate )
            VALUES  (
                      @UserID,
                      @ThreadID,
                      @Rate
                    )
        END

GO