"Jon Derbyshire" <JonDerbyshire@discussions.microsoft.com> wrote in message
news:E476C459-477C-4882-A705-674A19D20198@microsoft.com...
> Hi,
>
> I run the following query "SELECT * FROM tbl_A", and get the following
> result set:
>
> Surname Firstname
> Smith John
> Smith Richard
> Smith Simon
>
> What I want to see in my result set is:
>
> Surname Firstname
> Smith John, Richard, Simon
>
> How do I achieve this?
>
> Thanks
>
> Jon Derbyshire

"Adam Machanic" wrote:

> Can you do it in the client? This kind of thing is extremely inefficient in
> SQL Server.
>
> If you must do it in SQL Server, refer to the following:
>
> http://www.aspfaq.com/show.asp?id=2529
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> www.apress.com/book/bookDisplay.html?bID=457
> --
>
>
> "Jon Derbyshire" <JonDerbyshire@discussions.microsoft.com> wrote in message
> news:E476C459-477C-4882-A705-674A19D20198@microsoft.com...
> > Hi,
> >
> > I run the following query "SELECT * FROM tbl_A", and get the following
> > result set:
> >
> > Surname Firstname
> > Smith John
> > Smith Richard
> > Smith Simon
> >
> > What I want to see in my result set is:
> >
> > Surname Firstname
> > Smith John, Richard, Simon
> >
> > How do I achieve this?
> >
> > Thanks
> >
> > Jon Derbyshire
>
>