MDX functions (e.g. IIF(), IsEmpty()) in Client Tool - Query Analy
- From: slintz <slintz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 17:27:15 -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: MDX functions (e.g. IIF(), IsEmpty()) in Client Tool - Query Analy
- From: Jasper Smith
- Re: MDX functions (e.g. IIF(), IsEmpty()) in Client Tool - Query Analy
- Prev by Date: Re: Can't install SQL 2000 server
- Next by Date: Can SQL 2000 Analysis Services be installed on SBS 2003?
- Previous by thread: using MSDE
- Next by thread: Re: MDX functions (e.g. IIF(), IsEmpty()) in Client Tool - Query Analy
- Index(es):
Relevant Pages
|
