spGetSitePollResults

    CREATE PROCEDURE dbo.spGetSitePollResults
    (
        @SitePollsID int
    )
    AS

    select spa.Answer, count(spr.ID) as 'count'
    from SitePolls sp 
            INNER JOIN SitePollAnswers spa ON
                spa.SitePollsID = sp.ID 
            LEFT OUTER JOIN SitePollResults spr ON
                spr.SitePollAnswersID = spa.ID
    where sp.ID = @SitePollsID
    group by spa.Answer, spa.SeqNbr
    order by spa.SeqNbr