0 out of 2 rated this helpful - Rate this topic

- (Except) (MDX)

SQL Server 2005

Other Versions

Performs a set operation that returns the difference between two sets, removing duplicate members.

Syntax

Copy


Set_Expression - Set_Expression

Parameters

Set_Expression: A valid Multidimensional Expressions (MDX) expression that returns a set.

Return Value

A set that contains members that are not shared by both specified parameters.

Remarks

The - (Except) operator is functionally equivalent to the Except function.

Examples

The following example demonstrates the use of this operator.

Copy

// This query shows the quantity of orders for all products,
// with the exception of Assembly Components, which are not
// sold.
SELECT 
   [Date].[Calendar Month of Year].Children ON COLUMNS,
   [Product].[Product Categories].[All].Children 
   - [Product].[Product Categories].[Assembly Components] ON ROWS
FROM
    [Adventure Works]
WHERE
    ([Measures].[Order Quantity])

Reference

MDX Operator Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ