What's wrong with this UPDATE FROM using a case statement?
Posted
by Blankman
on Stack Overflow
See other posts from Stack Overflow
or by Blankman
Published on 2010-04-24T17:01:32Z
Indexed on
2010/04/24
17:03 UTC
Read the original article
Hit count: 195
update p
set
p.storePrice =
CASE
WHEN
p.costPrice BETWEEN 0.00 AND 1.00
THEN p.costPrice * 1.0
CASE
WHEN
p.costPrice BETWEEN 0.00 AND 1.00
THEN p.costPrice * 1.0
ELSE
p.msrpPrice
END
FROM product p
WHERE p.type = 1
The error says:
Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the keyword 'CASE'.
I can't seem to see any issue with the sql?
© Stack Overflow or respective owner