[BomBom]

استخدم دى

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