Issue with SQL Server Insert Statements and SubQueries
I recently got this error when applying a data fix. The error was for an insert that contains a select, I used the values keyword like:
insert into <table> (<fields>) values (1, 2, (select ...), 4)
The article referenced below indicates doing:
insert into <table> (<fields>) select 1, 2,(select ...), 4 -- notice no parens for outer select
You can see that post here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36506