SELECT FROM <model>.SAMPLE_CASES (DMX)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns sample cases that are representative of the cases that are used to train the data mining model.
To use this statement, you must enable drillthrough when you create the mining model. For more information about enabling drillthrough, see CREATE MINING MODEL (DMX), SELECT INTO (DMX), and ALTER MINING STRUCTURE (DMX).
Sample cases may be generated and may not actually exist in the training data. The returned case is representative of the specified content node.
Although the Microsoft Sequence Clustering algorithm is the only Microsoft algorithm that supports using SELECT FROM <model>.SAMPLE_CASES, third-party algorithms may also support it.
The following example returns sample cases that are used to train the Target Mail mining model. Using the IsInNode (DMX) function in the WHERE clause returns only cases that are associated with the '000000003' node. The node string can be found in the NODE_UNIQUE_NAME column of the schema rowset.
Select * from [Sequence Clustering].SAMPLE_Cases WHERE IsInNode('000000003')