Syntax error

[sva0008]

I am writing a dynamic query

insert into Tablename select '1111',
name,address,phone,'1111', exec usp_storedProcedureName '1111', '1111', 'KA','EA'
from edi856Item
where autoid = '1111'

I dont know why I am getting this error i think there is some syntax error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'exec'.
Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'from'.

Can anyone help please

[ronverdonk]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[ashokkumarpdi]

I am writing a dynamic query

insert into Tablename select '1111',
name,address,phone,'1111', exec usp_storedProcedureName '1111', '1111', 'KA','EA'
from edi856Item
where autoid = '1111'

I dont know why I am getting this error i think there is some syntax error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'exec'.
Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'from'.

Can anyone help please

Hi,

Try with the following insert statement, in ur insert statement one comma(,) is missing....

 
      INSERT INTO Tablename SELECT '1111',
        name,address,phone,'1111','exec usp_storedProcedureName', '1111', '1111', 'KA','EA'   FROM edi856Item
         WHERE autoid = '1111'

Regards,
S.Ashokkumar