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).
Predicts future sequence values for a specified set of sequence data.
The following example returns a sequence of the five products that are most likely to be purchased by a customer in the Adventure Works DW Multidimensional 2012 database based on the Sequence Clustering mining model.
SELECT PredictSequence([Sequence Clustering].[v Assoc Seq Line Items],5) From [Sequence Clustering]