If Statement not working

Question

Post reply

If Statement not working

kbnyny

Ten Centuries

Points: 1038
More actions
July 6, 2010 at 2:39 pm

#143987

I'm trying to write this select statement it will run without the if statement but once I put the if statement it will not run.
What I'm trying to do is have the query run with all Doc after 9/30/2009 and with Current Transaction Amt is > 0 and Transaction Amt is >= the Current Transaction Amt. Then If the Transaction Amt is = Current Transaction Amt then set the Current Transaction Amt to 0.
SELECT DOCDATE, POSTDATE, DOCNUMBR,
CURNCYID, TRXAMT, CURTRXAM
FROM CUSTCARD
WHERE (DOCDATE > '9/30/2009') AND (CURTRXAM > '0') AND
(TRXAMT >= CURTRXAM) and
IF TRXAMT = CURTRXAM
set CURTRXAM = '0
Thanks for your help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

You cannot use IF in a DML statement. You should use a CASE expression.

Example:

case when TRXAMT = CURTRXAM then 0 else CURTRXAM end

kbnyny Ten Centuries Points: 1038 More actions · Answer 2

I received this error msg when I put in that case statement "An expression of non-boolean type specified in a context where a condition is expected, near 'end'."

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 3

kbnyny (7/6/2010)
I received this error msg when I put in that case statement "An expression of non-boolean type specified in a context where a condition is expected, near 'end'."

Since you didn't post the actual code the received the error, you will have to debug that yourself.

I suggest you read about how to use CASE in SQL Server Books Online.