Wednesday, March 21, 2012

How to create a stored procedure to query the data mining model?

How to create a stored procedure to query the data mining model?

Where can I find some sample code?

Thanks.

Joe.

Details on how to create a stored procedure can be found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/SQLDMPrgrm.asp whitetaper

In the "Extending the Functionality of SQL Server Data Mining" section there are multiple examples of stored procedures. One of them, ExecuteContentQuery, shows exactly how to execute a (content) query over a mining model. The content query can be replaced with any other DMX query returning flattened results

Hope this helps

|||Thanks Bogdan

No comments:

Post a Comment