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'.
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;
ASKER
Adaptive Server Enterprise/11.9.2/1031/P/S un_svr4/OS 5.5.1/FBO/Fri Aug 14 06:26:45 1998,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do a "select @@version" and post the results.
Thanks,
Bill