Export (0) Print
Expand All
2 out of 6 rated this helpful - Rate this topic

RowNumber Function

SQL Server 2000

RowNumber Function

Returns a running count of all rows in the specified scope.

Syntax
RowNumber(Scope)
Parameters
Scope
(String) The name of a dataset, grouping, or data region that contains the report items to which to apply the aggregate function. If a dataset is specified, the running value is not reset throughout the entire dataset. If a grouping is specified, the running value is reset when the group expression changes. If a data region is specified, the running value is reset for each new instance of the data region. For more information about the Scope parameter, see Aggregate Functions.
Return Type

Returns an Integer.

Example

The following code example provides a running count of rows in the outermost data region:

RowNumber(Nothing)
See Also

Aggregate Functions

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