Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Level Function

SQL Server 2000

Level Function

Returns the current level of depth in a recursive hierarchy.

(String) The name of a dataset, grouping, or data region that contains the report items to which to apply the aggregate function. Scope is optional.
Return Type

Returns an Integer. If Scope specifies a dataset or data region, or specifies a nonrecursive grouping (that is, a grouping with no Parent element), Level returns 0. If Scope is omitted, it returns the level of the current scope. For more information about the Scope parameter, see Aggregate Functions.


The value returned by the Level function is zero based; that is, the first level in a hierarchy is 0.

The Level function can be used to provide indentation in a recursive hierarchy, such as an employee list. For more information about recursive hierarchies, see Grouping Data in a Report.


The following code example provides the level of row in the Employees grouping:

See Also

Other Functions

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.