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

Author  Topic 

lenakarthike
Starting Member

5 Posts

Posted - 2005-01-27 : 07:23:40
i have two columns in table like opid, srcno.

table structure is
opid srcno
10 222
10 343
10 293
10 394
10 983

but i need resultset like


opid srcno
10 222,343,293,394,983

please help me to get resultset


karthik
MCDBA,MCSA,ITIL

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-27 : 07:36:41
Read these
http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv



Damian
Go to Top of Page

lenakarthike
Starting Member

5 Posts

Posted - 2005-01-29 : 02:38:19
i am using sqlserver 7.0
it is support the function.


karthik
MCDBA,MCSA,ITIL
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-29 : 03:36:30
There a few solutions there, find one that works for you.

Are you really an MCDBA ?



Damian
Go to Top of Page
   

- Advertisement -