CREATE PROCEDURE dbo.[Forum_Polls_PollGet] @PollID INT
AS
    SELECT  PollID,
            Question,
            ShowResults,
            CreatedDate,
            EndDate,
            TakenMessage,
        ThreadID,
        ModuleID,
        (SELECT COUNT(UserAnswerID) FROM dbo.Forum_Polls_UserAnswers WHERE PollID = @PollID) As TotalVotes
    FROM    dbo.Forum_Polls_Polls
    WHERE   PollID = @PollID

GO