United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Data Mining Extensions (DMX) Reference

DMX Function Reference

BottomCount

BottomPercent

BottomSum

Cluster

ClusterProbability

IsDescendant

IsInNode

Lag

Predict

PredictAdjustedProbability

PredictAssociation

PredictCaseLikelihood

PredictHistogram

PredictNodeId

PredictProbability

PredictSequence

PredictStdev

PredictSupport

PredictTimeSeries

PredictVariance

RangeMax

RangeMid

RangeMin

TopCount

TopPercent

TopSum

This topic has not yet been rated - Rate this topic

IsDescendant

SQL Server 2005

Other Versions

Indicates whether the current node descends from the specified node.

Syntax


IsDescendant(<NodeID>)

Return Type

A Boolean type.

Remarks

IsDescendant is only used in SELECT FROM <model>.CONTENT (DMX) and SELECT FROM <model>.DIMENSION_CONTENT (DMX) queries.

Examples

The following example returns all the cases that are descendents of the node that is specified in the IsDescendant function.

SELECT * FROM [TM Decision Tree].CONTENT
WHERE IsDescendant('00000000100')

Reference

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

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 Additions

ADD

Manage Your Profile

Site Feedback