trainmapstructurewithnestedtable.dmx

来自「< SQL Server2005程序设计>」· DMX 代码 · 共 22 行

--Processing a mining structure with a nested table and training the model
INSERT INTO PurchaseAssociations(
  [Customer Key]
  ,[Customer Purchases] 
    (
      SKIP
      ,[Product Subcategory]
    )
)
SHAPE{
  OPENQUERY([Adventure Works DW],
    'SELECT CustomerKey 
     FROM AdventureWorksDW.dbo.vCustomerProfitability 
     ORDER BY CustomerKey')
  }
APPEND ({
  OPENQUERY([Adventure Works DW],
    'SELECT CustomerKey, ProductSubcategory
     FROM AdventureWorksDW.dbo.vCustomerPurchases
     ORDER BY CustomerKey'
)}
RELATE CustomerKey TO CustomerKey) AS CustomerPurchases