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-28 : 04:44:42
i have a table with following columns
OPID 4 int
SrcNo 12 varchar
Name 12 varchar

and table has values like
opid name srcno
394 ringwel 972
394 ringwel 961
394 ringwel 965
394 ringwel 967
394 ringwel 964
394 ringwel 9710
394 ringwel 962
394 ringwel 9810
394 ringwel 963

i need two type of report

(i)
opid srcno
394 972,961,965,967,964,9710,962,9819

(ii)

name srcno
ringwel 972,961,965,967,964,9710,962

my sql server version is 7.00.

pls help me to get resultset.



karthik
MCDBA,MCSA,ITIL

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-28 : 05:30:45
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45217

Damian
Go to Top of Page
   

- Advertisement -