GSquared (3/10/2011)
I've got a two-step script that can generate a nested sets "path" from an adjacency hierarchy, turning it into a nested sets hierarchy, using Cross Apply and a ranking function.
Is that method in the good article you wrote on hierarchies, Gus?
--Jeff Moden
Change is inevitable... Change for the better is not.