declare @i int; set @i = 1; while (@i < 100000) begin declare @mod int; set @mod = @i % 3; if @mod = 0 insert into sub_class_a(column_a) values(@mod) else if @mod = 1 insert into sub_class_b(column_b) values(@mod) else insert into sub_class_c(column_c) values(@mod) set @i = @i+1 end