Insert into table with multiple values in subquery

Question

INSERT INTO Reference_TB] ([RequestID] ,[WaveID]) 
VALUES (2222,(select tWaveID from @Table2))

I am using above query to insert into table. I know @Table2 has multiple tWaveID and that's why it is showing error :

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

How to resolve that and insert twaveID repeating RequestID as 2222 for all entries?

Sirko · Accepted Answer · 2012-11-23 15:47:07Z

7

Use the INSERT ... SELECT statement instead of a subquery:

INSERT INTO Reference_TB] ([RequestID] ,[WaveID]) 
(select 2222, tWaveID from @Table2)

answered Nov 23, 2012 at 15:47

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

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

1 Comment

Boris Over a year ago

Great one! This did exactly what I wanted. However, in SQL Server, I get syntax error if I put the columnName FROM Table part at the head of the SELECT list. It has to be at the end. Do you know why that is?

AbstractChaos · Accepted Answer · 2012-11-23 15:46:49Z

4

Unsure of exact syntax as you didnt specify a system.

use a Insert select will insert all values

INSERT INTO Reference_TB] ([RequestID] ,[WaveID])
select 2222,tWaveID from @Table2

answered Nov 23, 2012 at 15:46

AbstractChaos

4,2111 gold badge21 silver badges28 bronze badges

Collectives™ on Stack Overflow

Insert into table with multiple values in subquery

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related