Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 a sql query related question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-21 : 06:32:02
Naresh writes "I have to display the columns retrieved in a sql query corresponding to a unique Id in a row seperated by commas , how that can be done with the help of sql query itself .

The format is shown below :

Column A Column B
1 A
1 B
1 C
2 D
2 E

output required :

1 A,B,C
2 D,E.

Thanx in advance."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-06-21 : 06:41:05
Refer this
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-21 : 06:43:03
Or, without even leaving the SQL Team web site, try these:

http://www.sqlteam.com/searchresults.asp?SearchTerms=csv
Go to Top of Page
   

- Advertisement -