sql insert into with sub-query

Question

I want to run this query

INSERT INTO [tblPollLogs]
           ([lastModified]
           ,[ip]
           ,[a1]
           ,[a2]
         )
     VALUES
           (getdate()
           ,'aaa'
           ,(select top 1 header from [tblPollAnswer] where [pollAnswerId] = @param1)
           ,(select top  1 header from [tblPollAnswer] where [pollAnswerId] = @param2)         
         )

But I get the error

Subqueries are not allowed in this context. Only scalar expressions are allowed.

can i run this query in one query or i need get the values before running this query

thanks

In SQL Server 2008+ subqueries are fine there. BTW: Why are you using top 1 with no order by? If there is more than one matching row it is undeterministic what will be inserted and if there isn't more than one matching row you don't need the top 1. — Martin Smith
– Martin Smith, Commented Sep 10, 2013 at 9:39

Robert · Accepted Answer · 2013-09-10 09:37:20Z

5

Try to change it to insert...select as below

INSERT INTO [tblPollLogs]
           ([lastModified]
           ,[ip]
           ,[a1]
           ,[a2]
         )
select getdate(),
       'aaa',
      (select top 1 header from [tblPollAnswer] where [pollAnswerId] = @param1),
      (select top  1 header from [tblPollAnswer] where [pollAnswerId] = @param2)

answered Sep 10, 2013 at 9:37

Robert

25.8k8 gold badges70 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

sql insert into with sub-query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related