syntax error

Question

Post reply

syntax error

hbtkp

SSCommitted

Points: 1731
More actions
March 30, 2012 at 1:57 pm

#266472

hi
whats wrong with this exp
=iif(trim(cstr(Fields!Total.Value ="")),"?",iif(trim(cstr(isnothing(Fields!Total.Value))),"?",Fields!Total.Value))
plz help
this is int field

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Please post all replies to the initial thread:

http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

JeffRush SSC Eights! Points: 855 More actions · Answer 2

First glance: you have your comparison inside of the trim/cstr functions

trim(cstr(Fields!Total.Value =""))

vs

trim(cstr(Fields!Total.Value)) =""

also

iif(trim(cstr(isnothing(Fields!Total.Value)))

should likely be

iif(isnothing(trim(cstr(Fields!Total.Value)))

because you are not trimming and converting the results of the isnothing(), you are checking isnothing() against the trimmed and converted value of Total.

Jeff Moden SSC Guru Points: 1004280 More actions · Answer 3

SQLRNNR (3/30/2012)
Please post all replies to the initial thread:
http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx

According to that link, Jason... we're already there. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)