createstructurewithnestedtable.dmx

< SQL Server2005程序设计>

--Create a new mining structure
--Using Association Rules algorithm and nested table syntax
CREATE MINING MODEL PurchaseAssociations(
  [Customer Key] LONG KEY
  ,[Customer Purchases] TABLE PREDICT
    (
      [Product Subcategory] TEXT KEY 
     )
) USING Microsoft_Association_Rules