spGetSurveyAnswerResponseValues

        create procedure [dbo].[spGetSurveyAnswerResponseValues](@SiteSurveysAnswersId integer)
        as
            select a.AnswerValue 'Response', count(*) 'Total'
            from SiteSurveyResults a
            where a.SiteSurveyAnswersId = @SiteSurveysAnswersId
            group by AnswerValue