Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- From: "Jasper Smith" <jasper_smith9@xxxxxxxxxxx>
- Date: Fri, 5 Aug 2005 17:59:30 +0100
See reply in microsoft.public.sqlserver.setup
--
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
"slintz" <slintz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2D102C1-1023-413A-94D3-B82440DB08EC@xxxxxxxxxxxxxxxx
> 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?
>
.
- References:
- Prev by Date: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- Next by Date: Re: Stored procedure in Dynamic DB
- Previous by thread: How can I use MDX functions in SQL Query Analyzer (Client Tool)
- Next by thread: Re: Stored procedure in Dynamic DB
- Index(es):
Relevant Pages
|
