Convert Compound IIF To SQL Syntax

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Convert Compound IIF To SQL Syntax

Message

01/07/2008 13:26:32

Kevin Marois
Marois Consulting
Winchester, Californie, États-Unis

Tous

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Convert Compound IIF To SQL Syntax

Divers

Thread ID:

01327969

Message ID:

01327969

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform