Here is my take on it, I see 2 ways of doing it, both equally efficient just depends on what you want to do

declare @f2 as float;

select @f2 = cast(SUM(field2)...