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)
 sql query

Author  Topic 

rinki
Starting Member

1 Post

Posted - 2004-01-06 : 22:14:15
Hi everyone,

I have this table

ClientName Type Name
1 XYZ Test1
1 PQR Test1
1 JYX Test1
9 ert Test2
9 IUT Test2

I am trying to do something like this

Cleint Name Type Name Name
1 xyz, PQR, JYX Test1
9 ert, IUT Test2


Is it possible to do this in MS sql 2000. If it is Please let me know.

Any help will be greatly appreciated.

Thanks.

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-01-07 : 02:04:00
Yup... see http://www.sqlteam.com/item.asp?ItemID=2368

OS
Go to Top of Page
   

- Advertisement -