DECLARE @I int Declare @id int set @id=1 while @id<2365 begin SELECT @I =(SELECT [Ac] FROM StdItems where idx=@id )/10 update StdItems set ac=@i where idx=@id set @id=@id+1 end