Declare @x int; SET @x = 2 --> Spawnamount/2 UPDATE Tab_RefNest SET dwMaxTotalCount = CASE WHEN ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0) < 1 THEN 1 ELSE ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0) END