DECLARE @sum INT SET @v = 50 SET @sum = 0 WHILE @v<=100 BEGIN IF @v%2 <> 0 BEGIN IF @v%3 = 0 --SELECT @v SET @sum = @v + @sum END SET @v = @v+1 END SELECT @sum