Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Too many rows...

Author  Topic 

sgtwilko
Starting Member

23 Posts

Posted - 2001-10-19 : 06:35:27
I have a Table with contractor details, these contactors do work in 1 or more categories.

There were 200 categories.

The way the table was originally designed was having a bit field for every category.
But we now need to have more categories (300+), so any ideas on how to redesign the table so that we don't have 300+ bit fields?

   

- Advertisement -