Posted by rdraider on 07/18/07 18:50

Thanks for the info. My problem is the resulting data will be too large for
varchar(8000). All these examples seem to use varchar(8000)
I need to convert to a text datatype. I can concat multiple varchar fields
from 1 record into text but the problem is how the source data is
structured.
The source data is from an app called 'Onyx' running SQL 6.5 (I'm naming
names !!). I upgraded the SQL 6.5 to SQL 2000. I don't hav SQL 2005.

There is blog style data in the form of:

NoteID + NoteDetailID + SeqNum + Note1 + Note 2 + Note3 + Note4 + Note 5

NoteID is the same for each complete blog record
NoteDetailID changes for each new entry to the blog
SeqNum ranges from 1 - 20 for each NoteDetailID
The blog entries are stored in Note1 through Note5 - each only varchar(255)
As each Note field fills up, it rolls to Note2, Note3, Note4, Note5, then
creates a new record with same NoteID and NoteDetailID.
A new NoteDetailID is created when a new entry is started (such as a user
adds more to the blog days later)

I assume it was designed this way because SQL 6.5 largest data type was
varchar(255) ?

I have already created a temp table to combine the Note1 + Note 2 + Note3 +
Note4 + Note 5 into 1 varchar(8000) field.
Still looking for a method to properly combine the blog entries to text in
the proper order.

Thanks again for any ideas.

RD

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9970F2CF7D6CYazorman@127.0.0.1...
> rdraider (rdraider@sbcglobal.net) writes:
>> Using SQL 2000, how can you combine multiple records into 1?
>> The source data is varchar(255), the destination will be text. I need
>> help with the select statement.
>
> SQL Server MVP Anith Sen as a couple of methods on
> http://www.projectdmx.com/tsql/rowconcatenate.aspx.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How write this sentence with T-SQL
• Prev in forum: How write this sentence with T-SQL
• Thread view: Re: Combining many records into 1

[Reply to this message]