SQL Server Gems

Tuesday, May 08, 2007

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!

0 Comments:

Post a Comment

<< Home