Re: Limit of 1050 columns for ANSI joins

On Wed, 7 Jun 2006 14:06:42 -0700, "Andreas Sheriff"
<spamcontrol@xxxxxxxx> wrote:

One solution that I proposed was to create (a) separate table(s) for each
survey's responses, with each column being a response.


I have seen a different approach in operation
each record was one question, each column was a respondent. As the
number of choices was usually below 16, it was possible to store 2
respondents in a column, by using bit-masking.
Worked quite nicely!

--
Sybrand Bakker, Senior Oracle DBA
.