Crosstab?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon Derbyshire - 03 Nov 2005 14:49 GMT

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

Reply to this Message

Adam Machanic - 05 Nov 2005 20:54 GMT

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

Signature

Adam Machanic
Pro SQL Server 2005, available now
www.apress.com/book/bookDisplay.html?bID=457
--

> Hi,
>
[quoted text clipped - 16 lines]
>
> Jon Derbyshire

Reply to this Message

Jon Derbyshire - 07 Nov 2005 13:55 GMT

Thats brilliant - Thanks

> Can you do it in the client? This kind of thing is extremely inefficient in
> SQL Server.
[quoted text clipped - 23 lines]
> >
> > Jon Derbyshire

Reply to this Message