Posted by imani_technology_spam@yahoo.com on 12/07/05 21:35

Okay, now I have a new variation to this problem. Let's change the DDL
slightly:

CREATE TABLE [x_Note] (
[x_NoteId] [int] IDENTITY (1, 1) NOT NULL ,
[NoteCategory] [int] NOT NULL ,
[Note] [varchar] (7200) COLLATE
SQL_Latin1_General_Pref_CP1_CI_AS NOT
NULL ,


CONSTRAINT [PK_x_NoteId] PRIMARY KEY CLUSTERED
(
[x_NoteId],
) WITH FILLFACTOR = 90 ON [USERDATA] ,


) ON [USERDATA]
GO

Instead of combining the contents of the Note column for each row, we
need to combine the Notes within each NoteCategory. In other words, I
need to combine the Notes for all rows of NoteCategory #1, all the
Notes for NoteCategory #2, and so on.

In other words, FOR EACH NoteCategory, the clients want:

Note = Note [accumulated from previous rows within the NoteCategory] +
Char(13) [because they want a carriage return] + Note [from current
record within the NoteCategory].

Now, I have NO idea how to pull this off. I was considering nested
cursors, but I'm not sure if that is the best way, or even a practical
way. Help!!!

[Back to original message]