Use this as your guide
http://www.databasejournal.com/features/mssql/article.php/10894_3516331_2
Jaime E. Maccou
mailto:Jaime E. Maccou
"Our lives begin to end the day we become silent about things that matter."
- Dr. Martin Luther King, Jr.
"The mind does not take its complexion from the skin..."
- Frederick Douglass
There is always a way to do it better . . . find it!" Thomas A. Edison
DBA Ethical Rules
1. Don’t Lie
2. Don’t Cheat
3. Don’t Steal
4. Treat everyone fairly
5. Treat everyone equally"
-----Original Message-----
From: Julius Ghyoot
[mailto:mssqldba-ezmlmshield-x16875015.[Email address protected]
Sent: Tuesday, April 29, 2008 10:40 PM
To: LazyDBA Discussion
Subject: SQL Results Formating.
Hi Guys
Please help!
I have this query:
Select
d.ID AS ProdID,
p.Product
FROM tblDETAILS d
LEFT OUTER JOIN tblPRODUCT p ON d.ID = p.ID
Which Returns this:
ProdID Product
----------- ------------
10 222
10 333
20 777
20 888
(2 row(s) affected)
But I want it formatted like this:
ProdID Product
----------- ---------------
10 222, 333
20 777, 888
Is this possible?
Thanks
Julius
____________________________________________________________
This e-mail and any attachments may contain confidential information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page