Very useful updated DMX Syntax option in SQL Server SP2
If you have been playing with DMX, and wanted to do something like
SELECT PredictProbability([Gender], t.Gender)
FROM Customers
NATURAL PREDICTION JOIN
OPENQUERY([Movie Click], 'SELECT * FROM CUSTOMERS') AS t
Note: the t.Gender specified as input to the PredictProbaility(...) function.
Check out
http://blogs.msdn.com/jamiemac/archive/2007/04/25/new-dmx-syntax-option-in-sql-server-sp2.aspx#comments
Very useful, indeed!
SELECT PredictProbability([Gender], t.Gender)
FROM Customers
NATURAL PREDICTION JOIN
OPENQUERY([Movie Click], 'SELECT * FROM CUSTOMERS') AS t
Note: the t.Gender specified as input to the PredictProbaility(...) function.
Check out
http://blogs.msdn.com/jamiemac/archive/2007/04/25/new-dmx-syntax-option-in-sql-server-sp2.aspx#comments
Very useful, indeed!
0 Comments:
Post a Comment
<< Home