sql server - SQL UPDATE with CASE Statement Yields Incomplete ...

Is this is SQL limitation, or am I missing something? UPDATE a SET ResultType1 = CASE WHEN b.[Type] = 'type1' THEN b.value END ...

stackoverflow.com