>Having the questions in separate tables (which would solve things) is not an option because there can be thousands+ of them.
I am missing something. SQL Server 2000/2005 can handle MILLIONS of QUESTIONS.
Normally when you build a data warehouse you separate data into fact tables and dimension tables.
The dimension tables can be as low as 2 rows, as large as 20,000 (you can go higher, but performance issues arise).
The fact table is usually millions of rows (this is the big one).
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!