DECLARE @count INTEGER

DECLARE @id INTEGER

DECLARE @subjectID INTEGER

SET @count=1

SET @id =11894

SET @subjectID=151426

while @count<20

begin

update biomaterial set subject_id=@subjectID where id =@id

SET @count = @count +1

SET @id = @id +1

SET @subjectID =@subjectID +1

end