Link to home
Start Free TrialLog in
Avatar of vishali_vishu
vishali_vishu

asked on

sql error in sybase.

I am getting  the below error:

SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Server Message:  Number  102, Severity  15 Incorrect syntax near '('.
Server Message:  Number  102, Severity  15 Incorrect syntax near 'x'.
Server Message:  Number  102, Severity  15 Incorrect syntax near 'y'.



SELECT x.nsdorderno, x.notetext, y.notetext
  FROM (SELECT lgeproreqaudit.nsdorderno nsdorderno,
               lgeproreqnoteaudit.notetext notetext
          FROM lgeproreqnoteaudit, lgeproreqaudit
         WHERE (UPPER (lgeproreqnoteaudit.notetext) LIKE '%PTNII:%')
           AND lgeproreqaudit.objectid = lgeproreqnoteaudit.reqaudit_objectid
           AND datepart (yy, lgeproreqaudit.createdatetime) >= 2008) x,
       (SELECT lgeproreqaudit.nsdorderno nsdorderno,
               lgeproreqnoteaudit.notetext notetext
          FROM lgeproreqnoteaudit, lgeproreqaudit
         WHERE (UPPER (lgeproreqnoteaudit.notetext) LIKE '%TPR #%')
           AND lgeproreqaudit.objectid = lgeproreqnoteaudit.reqaudit_objectid
           AND datepart (yy, lgeproreqaudit.createdatetime) >= 2008) y  WHERE x.nsdorderno = y.nsdorderno;

Open in new window

Avatar of grant300
grant300

What Sybase product and version.  There are just too many to answer your question.

Do a "select @@version" and post the results.

Thanks,
Bill
Avatar of vishali_vishu

ASKER

Adaptive Server Enterprise/11.9.2/1031/P/Sun_svr4/OS 5.5.1/FBO/Fri Aug 14 06:26:45 1998,
ASKER CERTIFIED SOLUTION
Avatar of grant300
grant300

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial