> How can i update the source table with the output of data mining query
> which predicts value from the source table?

>
> > How can i update the source table with the output of data mining query
> > which predicts value from the source table?
>
> Make a cycle:
> - create a linked server from SQL Server to Analysis Services
> - you already have a linked server in AS to SQL through data source
> - use T-SQL Openquery function to run the DMX query
> - use DMX Openquery function to run the prediction join
> - don't forget to flatten the DMX result (FLATTENED keyword).
>
> Take a look at the example at
> http://solidqualitylearning.com/blogs/dejan/archive/2006/01/18/1507.aspx.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of the
> sender.
> This message does not imply endorsement from Solid Quality Learning, and it
> does not represent the point of view of Solid Quality Learning or any other
> person, company or institution mentioned in this message
>