Msg#: 3561992 posted 7:06 pm on Jan 30, 2008 (gmt 0)
I decided to restructure the database and changed a few things. It's all working now. I now have ParentHierarchy (n.n.n ...), Hierarchy (n.n.n ...) and IdHierarchy (id.id.id ...). This allows me to ORDER BY Hierarchy (because that's an absolute hierarchy where before was relative to the level as defined in IdHierarchy).