日期:2014-05-17 浏览次数:20556 次
SELECT
FLATTENED -- Force reuslt to be a flat table
PredictAssociation( -- The method for invoking association prediction
[Association].[v Assoc Seq Line Items], -- The column reference of the association
INCLUDE_STATISTICS, -- one of the options: include stat in the result set
10 -- top 10 associated items
)
FROM [Association] -- The model being queried
NATURAL -- Automatically make the join based on column names
PREDICTION JOIN -- Specify the input by using a JOIN
(SELECT
(SELECT 'Sport-100' as [Model]) -- 'Sport-100' is the input category
AS [v Assoc Seq Line Items])
AS t