CREATE PROCEDURE dbo.[Forum_Polls_AnswerGet] @AnswerID INT
AS
    SELECT  AnswerID,
            PollID,
            Answer,
            SortOrder,
            (SELECT COUNT(AnswerID) FROM dbo.Forum_Polls_UserAnswers WHERE AnswerID = @AnswerID) As AnswerCount
    FROM    dbo.Forum_Polls_Answers
    WHERE   AnswerID = @AnswerID

GO