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)
 GROUPING TEXT DATA

Author  Topic 

kepala
Starting Member

1 Post

Posted - 2001-06-25 : 22:16:37
HOW CAN I GROUP A COLLECTION OF TEXT DATA.

I created a table containing a text data column, an integer column, a char column.

The char column holds the group id of the text data and the integer column holds the order of the text in its group.

My question is how can I group each text file in their group in the order it is. I can do it in ASP/VB but can't seem to group them in t-sql

table example.

text              char             order
------------------------------------------
AAAAAAAAAAAAAAAA Chap1/Book1 1
AAAAAAAAAAAAAAAA

BBBBBBBBBBBBBBBB Chap1/Book1 2
BBBBBBBBBBBBBBBB

AAAAAAAAAAAAAAAA Chap1/Book2 1
AAAAAAAAAAAAAAAA

BBBBBBBBBBBBBBBB Chap1/Book2 2
BBBBBBBBBBBBBBBB



   

- Advertisement -