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
 General SQL Server Forums
 New to SQL Server Programming
 retrieve multiple values from table

Author  Topic 

jaimin
Starting Member

21 Posts

Posted - 2007-06-30 : 04:13:27
i am able to store multiple email ids in table (separated by comma).

now the problem is how do i retrieve those email ids from the table so that i can send mails to those email ids??




thanks
Jaimin

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-30 : 04:27:15
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85787
You want to store the CSV value in single row and single column or multiple row and single column


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-30 : 07:10:37
Store them in seperate rows
Read about Normalisation
http://www.datamodel.org/NormalizationRules.html



Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -