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)
 I know this has been asked before but...

Author  Topic 

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-11-08 : 19:00:38
Be damned if I can remember.

I have a table,
Key,seq, value

1,1,value1
1,2,value2
1,3,value3
1,4,value4
2,1,value1
2,2,value2

I need to combine them so it looks like
key1, value1 value2 value3 value4
key2, value1 value2

I'm still searching the site for an answer (I know it's in the forums..) any help would be appriciative


-----------------------
SQL isn't just a hobby, It's an addiction

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-08 : 19:05:54
Seek and ye shall find

http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv

Damian
Go to Top of Page

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-11-08 : 19:11:07
bleh, for some silly reason I didn't think of the term csv

Its late friday afternoon.. brain has shut off hours ago

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page
   

- Advertisement -