leastlikelycar.xmla

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

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
  <Command>
    <Statement>
      SELECT   TOP 250 t.FirstName, t.LastName, t.Phone,
               PredictProbability([Is Car Owner],'N') AS ProbNotCarOwner
      FROM	   CarOwner_DT
      PREDICTION JOIN
        OPENQUERY([Adventure Works DW],
        'SELECT c.FirstName,c.LastName,tc.*
         FROM   vCustomerProfitability tc
          INNER JOIN dimCustomer c ON tc.CustomerKey = c.CustomerKey')
        AS t
        ON t.Gender = CarOwner_DT.Gender AND
         t.IncomeGroup = CarOwner_dt.[Income Group] AND
         t.MaritalStatus = CarOwner_dt.[Marital Status] AND
         t.Region = CarOwner_dt.Region
      ORDER BY PredictProbability([Is Car Owner],'N') DESC
    </Statement>
  </Command>
  <Properties>
    <PropertyList>
      <Catalog>Chapter20</Catalog>
    </PropertyList>
  </Properties>
</Execute>