How can I use MDX functions in SQL Query Analyzer (Client Tool)
- From: slintz <slintz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 17:21:02 -0700
I'm very new to using MS-SQL stuffs and the IT dept here doesn't have any
DBMA to speak of. Thus, I'm a bit on my own - except for you helpful
people...
I just installed the Client Tools on my workstation and tried a simple query:
SELECT IIf(TBL.fld is NULL, "-N/A-", TBL.fld) FROM TBL;
and get the following error message:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'is'.
According to the help files, this should work, but clearly not. Is there
something(s) I need to enable, install, configure, tweek, activate, cajole,
or otherwise beg into acquiesence?
.
- Follow-Ups:
- Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- From: Jasper Smith
- Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- Prev by Date: TDS RPC protocol stream is incorrect
- Next by Date: Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- Previous by thread: TDS RPC protocol stream is incorrect
- Next by thread: Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- Index(es):
Relevant Pages
|
