Which table save matrix question answers?

[LAD]

Hi

I'm trying to learn some SQL querying and one of the things I've been looking at is learning the structure of the Ultimate Survey database under SQL.

My sample survey uses a matrix scale to pick a value of satisfaction. Out of interest where would these values be stored in the database/tables?

Cheers.

[jfischer]

All of the answers to all of the questions are in the usd_ResponseDetails table.

[LAD]

OK, thanks, can you point me in the direction of which column I should be looking for and does this column enter the actual value selected or reference elsewhere to a list of values?

For example, may scale has options 1-5, and 5 questions, if say someone chose all 3s, would 3 be the value shown in the row for that column.

I'm only just starting to work this all out; and as so much referenes other tables it's quite confusing for a beginner ;o)

Cheers.

[jfischer]

We generally do not provide support that delves that deeply into the structure of the database. If you are a customer though, you can request a database diagram through our Help Desk.

[LAD]

Thanks John.

I'm not sure that will help as I'm trying to identify specific answers through a survey I've created; hence just wanting to know if the values are stored as a value, number etc, obviously free text is easy to track down, but I'll check it out, got to be easier than the great big database diagram SQL Server produced!