Multiple columns in one single column
-
Multiple rows in single row.i have this kind of situation. i have multiple emails per person. (eg. business, private). i want display the name of the person and all their email in one column.
some thing like this.
column 1 column 2
row 1 Peter peter@yahoo.com,peter@hotmail.com,peter@itsl.com
row 2 John jonno@webmail.co.za,john2hotmail.com
-
Please can you clarify your design? It's unclear whether your email addresses are stored in separate columns in the same table or in a separate table that you're joining to.
-
Check out cadebryant 's article
Using UDFs to avoid cursors
: http://www.sqlservercentral.com/scripts/contributions/439.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply