How I Insert No of Rows Into Another table

Gurpreet Arora

11y778

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted answer
Hi,

You can use following options to inserts to other table:

1. Use trigger concept. Create a on insert trigger on test3 table. And inside that trigger fetch the column value and loop over it to insert new records to test4 table. Please follow below link to create trigger:

http://www.tech-recipes.com/rx/41414/sql-server-coding-the-after-insert-trigger-in-sql-server/

2. You can manually insert to test4 table based on test3 table. Create a stored procedure and insert record to test3 table. And then fetch column(No_of_test3) value, loop over it it insert records to test4 table. This simple and normal way.

Based on requirement you can use anyone of them.
+2
Amitesh Verma11y ago
drop table #temp2
create table #temp2 (id int identity(1,1),name varchar(20))
insert into #temp2 values('A10,B20,C34')
insert into #temp2 values('A11,B21,C31')
insert into #temp2 values('A12,B22,C32')

drop table #temp1
create table #temp1 (col1 varchar(3))

insert into #temp1 values('AA')
insert into #temp1 values('AA1')
insert into #temp1 values('AA2')
insert into #temp1 values('AA3')

declare @rowcounttable1 int,@rowcounttable2 int
select @rowcounttable2=COUNT(*) from #temp2
select @rowcounttable1=COUNT(*) from #temp1
select @rowcounttable1
select @rowcounttable2
--while(@rowcounttable2>@rowcounttable1)
while (@rowcounttable2<@rowcounttable1)
begin
set @rowcounttable1=@rowcounttable1-1

select @rowcounttable1
select @rowcounttable2
insert into #temp1 values('AA4')
end
select * from #temp1
+1