I have a survey with about 10 questions and about 3 differnat anwers on each questions, with branching.
But i would like to get out a kind of report of all possible combinations of answers from this.
I have made this view in SQL
SELECT TOP (100) PERCENT dbo.vts_tbQuestion.QuestionText, dbo.vts_tbAnswer.AnswerText, dbo.vts_tbAnswer.AnswerTypeId, dbo.vts_tbAnswer.AnswerIDText, dbo.vts_tbAnswer.AnswerAlias,
dbo.vts_tbQuestion.SurveyId, dbo.vts_tbBranchingRule.PageNumber, dbo.vts_tbBranchingRule.QuestionID, dbo.vts_tbBranchingRule.AnswerID, dbo.vts_tbQuestion.DisplayOrder
FROM dbo.vts_tbAnswer INNER JOIN
dbo.vts_tbQuestion ON dbo.vts_tbAnswer.QuestionId = dbo.vts_tbQuestion.QuestionId FULL OUTER JOIN
dbo.vts_tbBranchingRule ON dbo.vts_tbQuestion.QuestionId = dbo.vts_tbBranchingRule.QuestionID
WHERE (dbo.vts_tbQuestion.SurveyId = 4)
ORDER BY dbo.vts_tbQuestion.DisplayOrder, dbo.vts_tbBranchingRule.PageNumber
It there anyone that have a solution for this?