|
Home > Archive > MS SQL Data Warehousing > November 2005 > Crosstab?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jon Derbyshire 2005-11-03, 8:23 pm |
| 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 2005-11-08, 9:23 am |
| 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@discus
sions.microsoft.com> wrote in message
news:E476C459-477C-4882-A705- 674A19D20198@microso
ft.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
| |
| Jon Derbyshire 2005-11-08, 9:23 am |
| Thats brilliant - Thanks
"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@discus
sions.microsoft.com> wrote in message
> news:E476C459-477C-4882-A705- 674A19D20198@microso
ft.com...
>
>
>
|
|
|
|
|