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)
 Combining Records

Author  Topic 

MADTIES
Starting Member

6 Posts

Posted - 2006-02-08 : 08:56:50
Hello,

I'm trying to find a way to generate the desired result below. Currently my query will return a simple set of results such as

John 2
John 5
John 7

But I'd like to combine these to look like this.
John 2,5,7

Any suggestions for how to do this?

Thanks in advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-08 : 08:57:44
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 -