Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Displaying Sorted Hierarchies (SQL Spackle) RE: Displaying Sorted Hierarchies (SQL Spackle)
james-1071007
SSC Rookie
Points: 38
More actions
March 10, 2011 at 3:59 am
#1296975
That doesn't order correctly. You are relaying on the natural data order to provide the correct results.
Try inserting some extra records with lower manager id's and names beginning with z 😉