spGetSurveyResponseData

            CREATE procedure dbo.spGetSurveyResponseData
            (
                @SurveyID integer
            )
            as
                select
                    users.UserName,
                    response.ID as ResponseID,
                    response.MachineIP,
                    response.DateAdded,
                    results.SiteSurveyAnswersId as AnswerID,
                    results.SiteSurveyAnswerColumnsId as ColumnID,
                    results.AnswerValue,
                    ans.Answer,
                    q.Question,
                    q.SiteSurveyQuestionTypesID as QuestionType,
                    q.Sequence as QuestionSequence,
                    cols.ColumnName,
                    coldata.Data as DropDownSelection
                from dbo.SiteSurveyResponses response
                inner join dbo.SiteSurveyResults results
                    on response.ID = results.SiteSurveyResponsesId
                inner join dbo.SiteSurveyAnswers ans
                    on results.SiteSurveyAnswersId = ans.ID
                inner join dbo.SiteSurveyQuestions q
                    on ans.SiteSurveyQuestionsID = q.ID
                left outer join dbo.SiteSurveyAnswerColumns cols
                    on results.SiteSurveyAnswerColumnsID = cols.ID
                left outer join dbo.ClientUsers users
                    on response.ClientUsersID = users.ID
                left outer join dbo.SiteSurveyAnswerColumnData coldata
                    on results.AnswerValue = CAST(coldata.ID as nvarchar)
                where response.SiteSurveysID = @SurveyID