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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-11 : 08:05:15
|
| James Newey writes "I need to design a leads/contact database. Callcentre operators will pass through the data, updating old info, making sales cales and so forth. The trouble is, every client will have different requirements, different data that needs to be stored alongside the usual name and address fields. Is there a standard approach to this problem? Am I best off with a table for each client or is there a better way?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-11 : 08:06:54
|
| Without more specifics, it's hard to make a recommendation on table structure, except I can say that the better/best way does NOT use a separate table for each client. Doing something like that will become a programming and administrative nightmare very quickly. |
 |
|
|
|
|
|
Database design for variable fields