Hi All,

I know how to do this in Access, using VB, but I'm pretty new to SQL Server and have no idea how to even start.

Say you have a table, call it TblStudents, with two columns: Grade and Name. Then, say you want to write a view that groups the students by grade, so you know who got an A, etc, with each grade in one row.

So you start with the table looking like this:

Grade Name
A John
A Lisa
A Pat
B Fred
B Tina
C David
C Greg

And you want a view that gives a dataset looking like this:

Grade Name
A John, Lisa, Pat
B Fred, Tina
C David, Greg

How do you do this? It looks easy enough, but I've checked a couple of SQL Server books and online and while the question has been asked several times, I can find no clear answers.

Thanks.

Henry

This has been discussed manytimes in this forum. Take a look at this thread.

Concatenating like records

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection