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.
| Author |
Topic |
|
ed201
Starting Member
2 Posts |
 Posted - 2009-09-21 : 17:30:08
|
Hello,I have a table which has a column as a bit data type. I have another column as varchar to be populated with an answer if bit is 1 or yes. If bit is 0 or no, then is the column is left blank. I don't want to have a column that can answers filled in and null/blank column either. This leaves me the question, should I have another table that will have a FK relation and that the child table will have a column populated with answers that is based on the parent table if it is 1 bit or yes? This will help prevent unnecessary null values in the parent table if the bit was 0. Is this a good design or is there another solution.thanks all.  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ed201
Starting Member
2 Posts |
Posted - 2009-09-21 : 17:49:36
|
| Thanks Tara for the quick response, which I suspected. |
 |
|
|
|
|
|
table design???