Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Hierarchize

SQL Server 2000

Hierarchize

Orders the members of a set in a hierarchy.

Syntax

Hierarchize(«Set»[, POST])

Remarks

This function orders the members of «Set» in a hierarchy. Unless the POST keyword is used, members in a level are sorted in their natural order, which is the default ordering of the members along a dimension when no other sort conditions are specified. The POST keyword uses a post-natural order for the sorting of members in a level. Hierarchize will always retain duplicates.

Example

This example

Hierarchize(SampleSet)

returns the set in natural order. The hierarchized dataset follows (assuming that the natural order for the data source is alphabetical):

France
Nice
Paris
UK
London
USA
California
LA
Buffalo
NYC

Show:
© 2015 Microsoft