Insert statement inside while loop in SQL

Question

I want to insert the resultant rows of a query into another table. How can I perform this? Kindly help.

To better understand my question I simply execute the following query where I want the value of columnA to be the value of the column of the next row of the select statement in each iteration.

while exists (Select columnA from tableA where SOMECONDITION)
begin
    insert into tableB(columnA,Value1,Value2)
end

jarlh · Accepted Answer · 2016-01-21 14:06:27Z

3

Simply do an INSERT with SELECT:

insert into tableB select columnA, value1, value2 from tableA where SOMECONDITION

answered Jan 21, 2016 at 14:06

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Placinta Alexandru · Accepted Answer · 2016-01-21 14:13:21Z

0

You are complicating things, you need just insert entire projection from another table as result of a subquery:

INSERT INTO tableB SELECT columnA, Value1, Value2 FROM tableA WHERE *SOMECONDITION*;

answered Jan 21, 2016 at 14:13

Placinta Alexandru

5232 gold badges7 silver badges20 bronze badges

1 Comment

Sadii Over a year ago

The select query does not return a single row ,and value1 ,value2 are not the columns of of tableA.

Collectives™ on Stack Overflow

Insert statement inside while loop in SQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related