Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Compound IIF To SQL Syntax
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Convert Compound IIF To SQL Syntax
Miscellaneous
Thread ID:
01327969
Message ID:
01327969
Views:
48
How do I do this in SQL?
IIF(Trade.decTrade_Product_Balance <> 0 AND 
	(Trade.sTrade_Type_Pay_Rec = 'PAY' OR Trade.sTrade_Type_Pay_Rec AND Trade.sTran_Group_CD <> 'MAR'), 
		Transactions.decTrans_Amt, 0)
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform