Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 System.Data.OleDb.OleDbException: Incorrect synta

Author  Topic 

zhshqzyc
Posting Yak Master

240 Posts

Posted - 2010-01-07 : 12:58:11
Ignore it.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 13:04:23
is this full query? or is it part of batch?
Go to Top of Page

zhshqzyc
Posting Yak Master

240 Posts

Posted - 2010-01-07 : 13:08:44
It is a full query.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 13:12:03
whats purpose of ' around select sub queries in cte2?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 13:43:47
quote:
Originally posted by zhshqzyc

Ignore it.


why did you do that?
Go to Top of Page

zhshqzyc
Posting Yak Master

240 Posts

Posted - 2010-01-07 : 17:03:36
Sorry, it is the business code.
Just for the confidant reason.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-08 : 02:29:52
quote:
Originally posted by zhshqzyc

Sorry, it is the business code.
Just for the confidant reason.


then why post at all? in that case in future post a sample code to illustrate your problem rather than actual code
Go to Top of Page
   

- Advertisement -