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 |
|
CLEE25
Starting Member
14 Posts |
 Posted - 2010-03-18 : 09:07:44
|
| Hi all, I am working on a stored procedure that needs to push an array of interests to another site. The format I need is:NAME | EMAIL | INTERESTSJohn | Smith | Cats,Dogs,AlligatorsDave | Jones | Cats,PigsBill | Davis | CatsCurrently I have my Procedure outputtingNAME | EMAIL | INTERESTSJohn | Smith | CatsJohn | Smith | DogsJohn | Smith | AlligatorsDave | Jones | CatsDave | Jones | PigsBill | Davis | CatsSo, it there anyway to take those fields and combine them in a comma seperated field so instead of 6 records, I would only have three. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
CLEE25
Starting Member
14 Posts |
Posted - 2010-03-18 : 11:00:54
|
| Many thanks to you both for the answer and the fast reponse! |
 |
|
|
|
|
|
Is it possible to create a Comma Seperated Field?