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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 View Data SQL

Author  Topic 

papershop
Starting Member

27 Posts

Posted - 2012-06-28 : 03:55:16
Dear All

i have a problem in view data on sql, i have data like :

name member
erwin
ervin
Daniel
Dunga
Ferdinand

i would like to change view so the data will show like this

erwin, ervin, Daniel, Dunga, Ferdinan


what should i do. please help me

@papershop

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-06-28 : 07:51:51
Did you mean that you want to get the data as comma-separated values OR are you trying to get each name in a separate column?
Go to Top of Page
   

- Advertisement -