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 |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2008-05-14 : 12:57:25
|
| Hello,I will like to know the best practice for grouping email addresses in a table.We have a basic table that has email address for admin users. Which goes thusCLIENTS EMAILemailID intusername: varchar 20Client_email varchar 150The Above table is for our admin users. Enabling them to send out emails to clients. Based on their bills.We have a second table for mass mailing. Which has emails in groups. Each group is based on the above entry. And groups could range from 5 users up to 100,000 users.Whats the best way to implement this. Do I create a seperate column for each email entry, knowing that this table would be extremely big, with a lot of repeated values, ie username etc. Or group them TOGETHER as varchar(max)PLEASE ADVICE, best practicesthanksMaryYes O ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-14 : 13:05:17
|
| You should normalize it rather than grouping them together. Use three tables:Group table, user email table, and then a group/user email table that associates them together.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
grouping email address (Best Practice)