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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-07 : 17:57:01
|
Garth writes "SQL Team,
Is there any way to flag the end of an ORDER BY group of data.
ie. For the following statement:
SELECT * FROM table1 ORDER BY Surname, Age;
I'd like to have a flag in the recordset telling me when I get to the end of the 'Age' group and when I'm at the end of the 'Surname' group.
Thus when I get the recordset returned from the database my program can do the following:
do until recordset.fields("Surname").endOfGroup
write Surname heading
do until recordset.fields("Age").endOfGroup
write Age heading
loop
loop
At the moment I'm keeping track of where I am in the database by using variables in my program. I would like to get around this somehow." |
|
|
|
|
|
Flagging end of ORDER BY groups