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)
 multiple rows of data into one column

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-30 : 12:09:20
Anne writes "I have text data in SQL Sever 2000 which exist in multiple rows. Each line of text from a paragraph was put into a new row. I need to put the text altogether in a single text column for each record.

Any suggestions would be appreciated.

Thanks"

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2003-12-30 : 12:19:10
The following links demonsrate variations of how to do this.

http://www.sqlteam.com/item.asp?ItemID=256
http://www.sqlteam.com/item.asp?ItemID=11021
Go to Top of Page
   

- Advertisement -