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