CREATE PROCEDURE dbo.[Forum_Polls_UserAnswerAdd]
    @PollID INT,
    @UserID INT,
    @AnswerID INT
AS
    DECLARE @@VoteCount INT
    SET @@VoteCount = ( SELECT  COUNT(AnswerID)
                        FROM    dbo.Forum_Polls_UserAnswers
                        WHERE   PollID = @PollID
                                AND UserID = @UserID
                      )

    IF @@VoteCount < 1
        BEGIN
            INSERT  dbo.Forum_Polls_UserAnswers
                    (
                      PollID,
                      UserID,
                      AnswerID,
                      CreatedDate
                  )
            VALUES  (
                      @PollID,
                      @UserID,
                      @AnswerID,
                      GETDATE()
                    )
            SELECT  SCOPE_IDENTITY()
        END

GO