CODEWITHSUNDEEP
sqlinsert
Brijesh Kushwaha
Brijesh Kushwaha

Reputation: 273

Insert into table with multiple values in subquery

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?

Upvotes: 4

Views: 2081

Answers (2)

Sirko
Sirko

Reputation: 74036

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

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

Upvotes: 7

AbstractChaos
AbstractChaos

Reputation: 4211

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

Upvotes: 4

Related Questions