IsInNode

Indicates whether the specified node contains the current case.

Syntax

IsInNode(<NodeID>)

Return Type

A Boolean type.

Remarks

IsInNode is only used in SELECT FROM <model>.CASES (DMX) and SELECT FROM <model>.SAMPLE_CASES (DMX) queries.

Examples

The following example returns all the cases that were used to create the model that is associated with the node that is specified in the IsInNode function.

Select * from [TM Decision Tree].Cases
WHERE IsInNode('0')

See Also

Reference

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
Mapping Functions to Query Types (DMX)

Help and Information

Getting SQL Server 2005 Assistance