Survey Forums

HomeHomeSurvey Project ...Survey Project ...DevelopmentDevelopmenti bet no one  could solve thisi bet no one could solve this
Previous
 
Next
New Post
9/16/2016 4:53 PM
 

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?


 


 

 
Previous
 
Next
HomeHomeSurvey Project ...Survey Project ...DevelopmentDevelopmenti bet no one  could solve thisi bet no one could solve this