declare @current as int
declare @delta as int
declare @count as int
set @delta = 50000
select  @current = min(data_id) from fact_data where milliseconds is null;
select  @count = max(data_id) from fact_data;
--RAISERROR( convert(@count ,varchar(10)) + '', 0, 1) WITH NOWAIT;
while(@current < @count)
begin
update fact_Data set milliseconds = 0 where data_id >= @current and data_id < (@current + @delta) and milliseconds is null;
set @current = @current + @delta;
--RAISERROR ( 'count = ' + cast(@current as varchar(10)) + '', 0, 1) WITH NOWAIT;
end;