Home All Groups Group Topic Archive Search About

Combine results into one field

Author
23 Mar 2006 8:31 PM
Joey Martin
If I do a basic query
select * from grouping where code='12345'
I get the results
(fields are code,result)
12345     aaaaa
12345     assas
12345     f5fgh


I NEED to get it as aaaaa,assas,f5fgh. Since code is all the same, I
just want one result. Possible?

*** Sent via Developersdex http://www.developersdex.com ***

Author
23 Mar 2006 8:49 PM
Aaron Bertrand [SQL Server MVP]
http://www.aspfaq.com/2529



Show quote
"Joey Martin" <j***@kytechs.com> wrote in message
news:eUn4NjrTGHA.4308@TK2MSFTNGP10.phx.gbl...
> If I do a basic query
> select * from grouping where code='12345'
> I get the results
> (fields are code,result)
> 12345     aaaaa
> 12345     assas
> 12345     f5fgh
>
>
> I NEED to get it as aaaaa,assas,f5fgh. Since code is all the same, I
> just want one result. Possible?
>
> *** Sent via Developersdex http://www.developersdex.com ***

AddThis Social Bookmark Button