Table Data
Index FirstName LastName
1 Doug Reid
2 Laura Rie
3 Jerry Jones
4 Carl Lind
5 Kelly Ham
I'm trying to write a SQL statement where I list of names in a table will be converted so that each new name is separated by a comma.
Desired Results:
Doug Reid, Laura Rie, Jerry Jones, Carl Lind, KellyHam
FirstName(tablename) LastName(tablename)
from tablename
Any suggestions. Does it have to be a procedure?
Index FirstName LastName
1 Doug Reid
2 Laura Rie
3 Jerry Jones
4 Carl Lind
5 Kelly Ham
I'm trying to write a SQL statement where I list of names in a table will be converted so that each new name is separated by a comma.
Desired Results:
Doug Reid, Laura Rie, Jerry Jones, Carl Lind, KellyHam
FirstName(tablename) LastName(tablename)
from tablename
Any suggestions. Does it have to be a procedure?