How I Insert No of Rows Into Another table

Question

Hi 

 

 

Create table test3

(

Id int primary key identity(1,1),

No_of_test3 int,

Name varchar(50),

)

Create table test4

(

test4id int primary key identity(1,1),

test4Name varchar(50),

test3id int foreign key references test3(id)

)

 

I want to Insert value into Test4  on the basis of test3   

In Table test3   No_of_test3 int is 5 then i want 5 rows in test 4