>UPDATE Client > SET NoType= > CASE > WHEN Client.NoCompany=0 AND Client.NoProvince>0 THEN 1 > WHEN Client.NoCompany>0 THEN 2 > END >>
>UPDATE Client > SET NoType= > CASE > WHEN Client.NoCompany=0 AND Client.NoProvince>0 THEN 1 > WHEN Client.NoCompany>0 THEN (SELECT Company.Activated FROM Company WHERE Company.Numero=Client.NoCompany)=3 > END >>
WHEN Client.NoCompany>0 THEN case when (SELECT top (1) Company.Activated FROM Company WHERE Company.Numero=Client.NoCompany)=1 then 2 else 3 end end