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 PROBLEM!

Author  Topic 

xpandre
Posting Yak Master

212 Posts

Posted - 2002-07-17 : 08:11:28
Hi,
1 sql of mine gives me 5 rows . like this

a1
a2
a3
a4
a5

i want this in this way in a single row
a1,a2,a3,a4,a5

how can i get this in a single sql?

thanx
Sam


dsdeming

479 Posts

Posted - 2002-07-17 : 08:21:06
Take a look at:

[url]http://www.sqlteam.com/item.asp?ItemID=2368[/url]

Go to Top of Page
   

- Advertisement -