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


SQL Server 2005 query that uses the IIF with style date bool ?
View
Options
Author
Message
Dong Trien Lam
Dong Trien Lam
Dong Trien Lam
posted 8 Years Ago
StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)StrataFrame User (173 reputation)
Group: Anonymous / Guest
Posts: 57, Visits: 251
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:
SELECT quantity, Price, Returns, IIF ([Returns] = 0, ([quantity]*[Price]), (-1)*([quantity]*[Price])) As Total
FROM TABLE;


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.
Reply Like 1
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
SQL Server 2005 query that uses the IIF with style date bool ?
Dong Trien Lam - 8 Years Ago
     That IIF statement only exists in MDX - the query language for SQL...
Yasar Askari - 8 Years Ago
             Ok, thank you
Dong Trien Lam - 8 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 2 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search