"My friends, you bow to no one" - Aragorn, to the hobbits, Return of the King
In a recent post made for my reference, I came posted the syntax for the SQL Server CASE statement, because I always forget some of the finer points of less used syntax.
Well, it just so happens that I also found myself recently needing the syntax for a CASE statement used inside an update.
In keeping with the other posting, this seems a mighty fine place to record such a thing
update mytable set col1 = (CASE WHEN (condition) THEN (value) ELSE (other value) END ) where column = value
Another quickie, mainly for my enjoyment at some stage down the road!