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

DrillupMember

SQL Server 2000

DrillupMember

Drills up the members in a specified set that are present in a second specified set.

Syntax

DrillupMember(«Set1», «Set2»)

Remarks

This function drills up the members in «Set1» that are present in «Set2». «Set2» is usually a subset of «Set1».

Example

This example

DrillupMember({Canada, Mexico, USA, Washington, Seattle},{Washington})

returns the set

{Canada, Mexico, USA, Washington}.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.