Error in sql query incorrect syntax near ')'

sql, sql-server

Solution

Try to add a table name (for example `T`) as below:

insert into p_article_client_detail_current(article_id,sector_detail_id)
select article_id,2818
from ( select article_id from p_article_client_detail_current
       where sector_detail_id=239 and convert(varchar(11),feed_date,101) >= '12/07/2012'
) T

If you don't need nested query you can also to use this query:

insert into p_article_client_detail_current(article_id,sector_detail_id)
select article_id,2818
from p_article_client_detail_current
where sector_detail_id=239 
and convert(varchar(11),feed_date,101) >= '12/07/2012'

Problem

``` insert into p_article_client_detail_current(article_id,sector_detail_id) select article_id,2818 from ( select article_id from p_article_client_detail_current where sector_detail_id=239 and convert(varchar(11),feed_date,101) >= '12/07/2012' ) ``` Msg 102, Level 15, State 1, Line 5 Incorrect syntax near ')' what is wrong with this query , please help .

Original source