Problemwit sql query
Posted
by phenevo
on Stack Overflow
See other posts from Stack Overflow
or by phenevo
Published on 2010-03-25T09:39:35Z
Indexed on
2010/03/25
9:43 UTC
Read the original article
Hit count: 510
Hi, I've got query:
INSERT INTO [Tasks]
([LoginName]
,[Type]
,[Filter]
,[Dictionary]
,[Description])
Select N'Anonymous',4,'SomeTable.targetcode in (select Code from cities where countrycode in ('TN')) and SomeTable.SomeValue in ('13','15')',3,N'Cities from tunis'
Union All
...
[Dictionary] is a part of query that i need to function on my server.
I get:
Incorrect syntax near ')) and SomeTable.SomeValue in (13,15)'.
© Stack Overflow or respective owner