CREATE PROCEDURE dbo.[Forum_UserThreadsAdd]
    @UserID INT,
    @ThreadID INT,
    @LastVisitDate DATETIME
AS
    DECLARE @tempCount INT

    SET @tempCount = ( SELECT   COUNT(ThreadID)
                       FROM     dbo.Forum_UserThreads
                       WHERE    UserID = @UserID
                                AND ThreadID = @ThreadID
                     )

    IF @tempCount < 1
        BEGIN

            INSERT  INTO dbo.Forum_UserThreads
                    (
                      UserID,
                      ThreadID,
                      LastVisitDate
                  )
            VALUES  (
                      @UserID,
                      @ThreadID,
                      @LastVisitDate
                  )
        END

GO