I have a big update command containing a WHERE clause which will take the value from a select but with a condition:

...
     WHERE BusinessTime.NoProvince=
      CASE
       WHEN (SELECT Company.NoCountry FROM Company WHERE Company.Numero=Client.NoCompany)=1 THEN
       (SELECT Company.NoProvince FROM Company WHERE Company.Numero=Client.Company) ELSE 84
       END AND
      BusinessTime.NoHoliday=0 AND
      BusinessTime.Start<Client.FirstDate AND
      BusinessTime.[End]>=Client.SecondDate) Temp)
...

Is there a way to avoid doing two select in the company table to satisfy that need?