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