Questionnaire script with multiple input types

Hi,
I'm working on a questionnaire which will include multiple input types
(check boxes, drop-downs, textarea) to submit answers. Currently, in
my design, I have 3 tables: Answer, Question, and Stream.
The same 5 questions are asked as they relate to the 8 streams of
course discipline - in other words, the 5 questions are asked 8 times
each. I had thought of using loops to accomplish this, although at
present the stumper is getting a graceful and effiicient means of
dealing with the different data types.
The first thing that came to mind was using a different table for each
different data type in the Answers. Would there be something perhaps
more simple and efficient?

Many thanks for any help,
Louis

ll ( ) writes:
> I'm working on a questionnaire which will include multiple input types
> (check boxes, drop-downs, textarea) to submit answers. Currently, in
> my design, I have 3 tables: Answer, Question, and Stream.
> The same 5 questions are asked as they relate to the 8 streams of
> course discipline - in other words, the 5 questions are asked 8 times
> each. I had thought of using loops to accomplish this, although at
> present the stumper is getting a graceful and effiicient means of
> dealing with the different data types.
> The first thing that came to mind was using a different table for each
> different data type in the Answers. Would there be something perhaps
> more simple and efficient?

Maybe the data type sql_variant can be useful?


--
Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx