Jeff Moden (10/2/2011)
I.... Since I haven't actually used the HierarchyID datatype (and, therefore, haven't used any of it methods up 'till now), I built myself a nice "little" million row "clean" table in the form of an Adjacency List (including an extra column called "Sales") and converted it to use the HierarchyID data-type. I used the indexes that Microsoft Suggested for such a thing.
Hi Jeff
I have not used this data type before...but am keen to learn more.
would you care to share your "little" million row test rig please?
regards jls
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day