I accept your way is the correct way, however I have an issue with the way the data will be inputted into the table.

For every questionnaire completed means...

thanks for quick reply. on average we have about 50 questions to set 150 cols to support extra questions.

I see your way accommodates for any length of questionnaires. ...

So returning more rows with a 1 column is better than returning less rows with more columns.

What if I have 100 questionnaires containing 50 questions with 100,000 participants complete each...

Hi Jeff

mmm, I see your point but are they any performance issues doing this.

I see we would be running the same amount of searches extracting the data.

Hi Jeff

This is single table that contains the following Fields:

ID [int] Identity

QuestionnaireID [int]

Q0 [smallint]

.

.

.

Q150 [smallint]

Don't think I can get it any normalized than it is, but if I am...

Hi Andras

Thanks

On average I would expect around 6 rows for looking up values 0 to 5.

These values come from questions so depending on how many options are listed...

Hi Andras

Thanks for the swift reply.

Not sure if this will work as I forgot to mention there are 150 fields Q1 to Q150

Tried to run script and got an error...