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 |
|
danielhai
Yak Posting Veteran
50 Posts |
 Posted - 2003-05-21 : 20:37:15
|
| This is referring to this article: [url=http://www.sqlteam.com/item.asp?ItemID=8866]Hierarchy Article[/url].I'm having a problem ordering the items if they have the same lineage - since the order by orders by the node ID, is there a way to order by another field if they are in the same lineage? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-05-21 : 21:08:30
|
| I got around this once by building the tree so that the node ids were in the same order as the column I wanted to order by.Damian |
 |
|
|
danielhai
Yak Posting Veteran
50 Posts |
Posted - 2003-05-22 : 17:58:07
|
| any way you can post an example?right now i'd have to re-order the nodes, or create new id's for the nodes. (for instance, i'm using the identity in my table as the NodeID) |
|
|
|
slacker
Posting Yak Master
115 Posts |
Posted - 2003-05-23 : 19:13:41
|
| Couldnt you specify additional fields to order by? Or are thesefields not available to order by.order by lineage asc,Lastname,Firstname |
|
|
|
|
|
|
Problem with Hierarchies