How can I use MDX functions in SQL Query Analyzer (Client Tool)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

slintz - 04 Aug 2005 01:21 GMT

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?

Reply to this Message

Jasper Smith - 05 Aug 2005 17:59 GMT

See reply in microsoft.public.sqlserver.setup

Signature

HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

> 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
[quoted text clipped - 14 lines]
> cajole,
> or otherwise beg into acquiesence?

Reply to this Message