declare @num int select @num = 1 while @num < 100 begin update titles set price = price * 1.1 select @num = @num + 1 end