Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
Michael Meierruth
SSChampion
Points: 10051
More actions
November 13, 2012 at 2:56 pm
#1558675
Jeff,
In the code for generating the tally table, you use this syntax:
row_number() over (order by (select null))
I have never see this before. But it works. What is this '(select null)' trick all about?
PS
Very, very neat article!