declare @i int; set @i = 1; while (@i < 100000) begin declare @mod int; set @mod = @i % 3; insert into base_class(sub_type) values(@mod) if @mod = 0 insert into inheriting_class_a(base_class_id) values(@i) else if @mod = 1 insert into inheriting_class_b(base_class_id) values(@i) else insert into inheriting_class_c(base_class_id) values(@i) set @i = @i+1 end