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)
 SQL Help

Author  Topic 

mbowling
Starting Member

1 Post

Posted - 2006-02-28 : 00:11:46
Hi,

I have the following data in a table in SQL Server:

ColumnA ColumnB

1031 06-8237
1031 06-1811
1031 06-9552
1032 06-9382
1032 06-8844

How do I construct an SQL query to produce the following output?

1031 06-8237 06-1811 06-9552
1032 06-9382 06-8844

Thank you.

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2006-02-28 : 00:30:10
Hi,
Refer this link..
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
Go to Top of Page
   

- Advertisement -