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
 Transact-SQL (2000)
 Data Display

Author  Topic 

olay80
Yak Posting Veteran

62 Posts

Posted - 2005-12-20 : 09:50:57
hey guys,

i have the following output from my sql:
1 A
1 B
1 C

but the problem is that i need the output to be like this:
1 A B C

on one row. i can do that using my code but it would be much easier if it could be solved using sql.

Oliver

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-20 : 09:51:55
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
   

- Advertisement -