You would have to write a UDF (user-defined function). See BOL. Since the
UDF is written in VB or some other COM-interfacing language, you have the
full ability to do whatever you want.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Terry M. Ledet" <terry.ledet (AT) sci-us (DOT) com> wrote
Quote:
Is it possible to executing/calling a stored proecdure or
user defined function in a SQL Server 2000 database using
MDX.
If so, how and where are the instructions?
Thanks
TML |