select sq.sortOrder, sq.surveyId, q.questionId, q.questionPrompt from tbl_SVY_Questions q inner join tbl_SVY_SurveyQuestions sq on sq.ownerId = q.ownerId and sq.ownerType = q.ownerType and sq.questionId = q.questionId where sq.surveyId = and q.questionName = 'EVENTQUESTION' order by sq.sortOrder
Order Text
Leave questions blank to remove