Incorrect syntax near ')'

Question

0.00/5 (No votes)

See more:

This is an SP,when i execute in SMStudio it getting error
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near ')'.

DECLARE @tblPossibleAudits TABLE (auditid int)

SELECT DISTINCT TBL.auditid, AD.auditname
FROM (
SELECT POS.auditid, COUNT(AJ.loanmasterid) as totalloans, COUNT(IMG.loanmasterid) as imgloadedloans
FROM @tblPossibleAudits POS INNER JOIN auditjunction AJ
ON AJ.auditid = POS.auditid LEFT JOIN ldocumentimages IMG)
ON IMG.loanmasterid = AJ.loanmasterid
GROUP BY POS.auditid
)
TBL INNER JOIN auditdescriptions AD
ON AD.auditid = TBL.auditid
WHERE TBL.totalloans > TBL.imgloadedloans
ORDER BY AD.auditname
FOR XML AUTO

Posted 9-Sep-12 21:44pm

Ali_100

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Accepted Answer · 2012-09-09T21:48:00

Try this:

SQL

SELECT DISTINCT TBL.auditid
			  , AD.auditname
FROM
	(SELECT POS.auditid
		  , count(AJ.loanmasterid) AS totalloans
		  , count(IMG.loanmasterid) AS imgloadedloans
	 FROM
		 @tblPossibleAudits POS
		 INNER JOIN auditjunction AJ
			 ON AJ.auditid = POS.auditid
		 LEFT JOIN ldocumentimages IMG
			 ON IMG.loanmasterid = AJ.loanmasterid
	 GROUP BY
		 POS.auditid
	)
	TBL
	INNER JOIN auditdescriptions AD
		ON AD.auditid = TBL.auditid
WHERE
	TBL.totalloans > TBL.imgloadedloans
ORDER BY
	AD.auditname
FOR XML
	AUTO

manognya kota · Accepted Answer · 2012-09-09T21:49:00

Solution 2

Hi,

i guess there is an extra ) after IMG.Try removing that.

Posted 9-Sep-12 21:49pm

manognya kota

Afzal Shaikh · Accepted Answer · 2012-09-09T21:49:00

Solution 3

ON AJ.auditid = POS.auditid LEFT JOIN ldocumentimages IMG)

remove ) from this line...

Thanks,

Posted 9-Sep-12 21:49pm

Afzal Shaikh

Incorrect syntax near ')'

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Incorrect syntax near ')'

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us