the same can be even achieved, instead of having 20 different columns,
in a single column varchar(20) vincs('11010111011101110010').
Luckys.
On 4/14/06, ivan marchesini <[EMAIL PROTECTED]> wrote:
Thank you very much!!!your suggestion seems really usefull!! I will try it very soon!!!ivan
Il gior
Thank you very much!!!
your suggestion seems really usefull!! I will try it very soon!!!
ivan
Il giorno gio, 13/04/2006 alle 11.34 -0700, Steve Crawford ha scritto:
> > I have a table where there are 20 columns named
> > vinc1, vinc2, vinc3, vinc4, etc
> >
> > the values contained into each
I have a table where there are 20 columns named
vinc1, vinc2, vinc3, vinc4, etc
the values contained into each column are simply 1 or 0 (each column is
dichotomic)
1 means presence
0 means absence
I would obtain a column (new_column) containg the name of the columns,
comma separated, where
Sorry, I'm not able to understand how I can use this solution!!!
can you better explain me your suggestion???
Thanks very much
Il giorno gio, 13/04/2006 alle 06.51 -0700, Richard Broersma Jr ha
scritto:
> Just a thought,
>
> Could you achieve that same result using the binary representation of
Just a thought,
Could you achieve that same result using the binary representation of an
integer?
Regards,
Richard
--- ivan marchesini <[EMAIL PROTECTED]> wrote:
> Dear users,
> I have this problem
>
> I have a table where there are 20 columns named
> vinc1, vinc2, vinc3, vinc4, etc
>
Dear users,
I have this problem
I have a table where there are 20 columns named
vinc1, vinc2, vinc3, vinc4, etc
the values contained into each column are simply 1 or 0 (each column is
dichotomic)
1 means presence
0 means absence
I would obtain a column (new_column) containg the name of the
