Hi All,
I"m a beginner in the world of SQL. I've made a basic query to find all our survey responses to the postcode / country question in last FY.
However, the results aren't showing what I'm expecting.
>They don't show any numbers above 3000 (postcodes go up to 9999 in australia) and
>they don't show any countries.
I've checked that this question is assigned as #1 in the TR_SURVEY_QUESTION TABLE
QUERY:
SELECT * FROM [dbo].[T_SURVEY_RESPONSE] WHERE question_no=1 AND create_dt BETWEEN '2017-07-01' AND '2018-06-30';
SAMPLE OF RESULTS:
We can get this info in T-stats but keen to compare in SSMS.
Thanks for any advice!
If your goal is just to report on these survey responses, you could consider configuring T-Stats to grab the questions you're interested in. It would then show you both the question and answer in T-Stats. You just need to use a System Table to tell T-Stats which questions you want included. By default T-Stats does not grab survey responses, but can be set to take up to 10 questions. There are more details on this functionality here: https://community.tessituranetwork.com/topical_groups/tstats/w/tstats-wiki/578/can-we-analyze-order-survey-responses-in-t-stats
I realize that won't necessarily shed light on what changes you may need to make to your own query, but it may obviate the need for it.