dbTalk Databases Forums  

SProc or UDF

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SProc or UDF in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry M. Ledet
 
Posts: n/a

Default SProc or UDF - 08-04-2003 , 09:15 AM






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

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: SProc or UDF - 08-05-2003 , 01:01 AM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.