spGetSurveyQuestions

            create procedure dbo.spGetSurveyQuestions
            (
                @SurveyID integer
            )
            as
                select
                    q.Question,
                    ans.Answer,
                    cols.ColumnName,
                    q.SiteSurveyQuestionTypesId,
                    q.Sequence
                from
                    dbo.SiteSurveyQuestions q
                inner join dbo.SiteSurveyAnswers ans 
                    on ans.SiteSurveyQuestionsID = q.ID
                left outer join dbo.SiteSurveyAnswerColumns cols
                    on cols.SiteSurveyQuestionsID = q.ID
                where
                    q.SiteSurveysID = @SurveyID
                order by q.Sequence ASC