Top "Iif" questions

The Immediate IF, which does not short-circuit, returns one of two values, depending on whether the boolean expression evaluates to true or false in SQL Server 2012, Visual Basic, and its variants.

IIF statement in SQL/ Informatica ( expression transformation) with two values

I have the following SQL statement which check for the presence of 000. But what if I want to check the …

sql informatica iif
report builder IIF() function with multiple TRUE value

I'm encountering an issue while develloping some report on RB. I have a tablix that where the columns are the …

reporting-services ssrs-tablix reportbuilder iif
Conditional Action in SSRS

I want my textbox to have an action ONLY if the condition is true, otherwise no action. This is what …

reporting-services ssrs-2008 iif-function iif
IIF statement in SQL Server 2005

Does IIF statement exists in all version of SQL Server ? I have checked a tutorial on MSDN. But when I …

sql-server sql-server-2005 iif
Error when combining IIF and 'Is Null'

I need to combine three columns representing address lines into one column, in order to compose the entire address here. …

sql-server syntax-error iif
MDX: IIf condition on the value of a dimension is always false

I am trying to produce a different output in a column dependent on whether the value of a dimension [Scenario].[…

sql-server ssas mdx ssas-2008 iif
ReportViewer IIf expression in text box returns #ERROR

I'm using ReportViewer for work and I'm trying to get an IIf expression to work with a few text boxes …

c# reportviewer iif
SSRS IIF Syntax with Multiple Datasets

I have a report with 2 data sets and would like to perform a SUM operation in a textbox expression. The …

reporting-services sql-server-2008-r2 expression iif
VB6 IIf advantage

Is there a performance advantage to using IIf over If? Other than simply less code... what is the difference between : …

if-statement vb6 iif
Multiple nested iif statement in Access

I am trying to calculate the number of vacation week an employee is entitled to using their years of service, …

ms-access nested iif