StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » SQL Server 2005 query that uses the IIF with style date bool ?

SQL Server 2005 query that uses the IIF with style date bool ?

Dong Trien Lam — Sun, 12 Jun 2016 21:21:25 GMT

Suppose I have TABLE with the following fields:

Quantity [number]

Price [Number]

Returns [bool]

If Returns = true, then - ([quantity]*[Price])// negative returns

If Returns = false, then ([quantity]*[Price]) // positive returns

Question using SQL Server 2005:

Inquiry following his error was in command IIF:

[CODE]

SELECT quantity, Price, Returns, IIF ([Returns] = 0, ([quantity]*[Price]), (-1)*([quantity]*[Price])) As Total

FROM TABLE;

[/CODE]

SQL Syntax Errors Encountered:

The following errors were encountered while parsing the contents of the SQL pane:

Error in list of function arguments: '=' not recognized. Unable to parse query text.

RE: SQL Server 2005 query that uses the IIF with style date bool ?

Dong Trien Lam — Sun, 12 Jun 2016 21:21:25 GMT

Ok, thank you

RE: SQL Server 2005 query that uses the IIF with style date bool ?

Yasar Askari — Sun, 12 Jun 2016 08:44:43 GMT

That IIF statement only exists in MDX - the query language for SQL Server Analysis Services - the datawarehousing side of SQL Server.

Plain T-SQL does not have an IIF statement.

The best you can do in T-SQL is use the CASE.... WHEN... THEN... statement.