Understanding the SQL Server CASE statement

Querying data using the SQL Case statement

SQL CASE Statement - Simple and Searched Forms - Essential SQL

SQL UPDATE from SELECT, JOIN or MERGE

How to UPDATE from a SELECT statement in SQL Server

Using a SQL Server Case Statement for IF/Else Logic

IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL

SQL Server CASE Expression Overview