October 31, 2011 at 7:15 am
Hi Friends,
When I tried to execute the following Query, I got the below mentioned error.Can any one help me out what the following Error means:-
🙂 3706: Syntax error:Expected Something between '(' and
the 'SELECT' Keyword. 🙂
I will be providing the Query below:-
SELECT
TEJPGLMA_LEAF.GL_CODE,
TEJPGLMA_LEAF.GL_DESC GLDESC,
TEJPGLMA_LEAF.LEAF,
TEJPGLMA_LEAF.PARENT_GL,
TEJPGLMA_LEAF.ULTI_PARENT,
TEJPGLMA_PARENT.GL_DESC PARENTDESC,
TEJPGLMA_ULTPARENT.GL_DESC ULTPDESC,
GLBAL.CCY_CODE AC_CCY,
(Case TEJPGLMA_LEAF.CATEGORY WHEN 3 then
(Select Sum(CASE GLBAL.CCY_CODE WHEN STBRN.BRANCH_LCY THEN
(Select Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN DR_BAL_LCY ELSE 0 END) - Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN 0 ELSE DR_BAL_LCY END)
FROM TEJPGLBL GLBAL1 Where GLBAL.BRANCH_CODE = GLBAL1.BRANCH_CODE And GLBAL.GL_CODE = GLBAL1.GL_CODE and GLBAL.PERIOD_CODE = GLBAL1.PERIOD_CODE and GLBAL.FIN_YEAR = GLBAL1.FIN_YEAR)
ELSE GLBAL.DR_BAL_LCY END))
WHEN 4 then
(Select Sum(CASE GLBAL.CCY_CODE WHEN STBRN.BRANCH_LCY THEN
(Select Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN DR_BAL_LCY ELSE 0 END) - Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN 0 ELSE DR_BAL_LCY END)
FROM TEJPGLBL GLBAL1 Where GLBAL.BRANCH_CODE = GLBAL1.BRANCH_CODE And GLBAL.GL_CODE = GLBAL1.GL_CODE and GLBAL.PERIOD_CODE = GLBAL1.PERIOD_CODE and GLBAL.FIN_YEAR = GLBAL1.FIN_YEAR)
ELSE GLBAL.DR_BAL_LCY END)) ELSE GLBAL.DR_BAL_LCY END)AS LCY_DEBIT,
/*(Case TEJPGLMA_LEAF.CATEGORY WHEN 3 then
(Select Sum(CASE GLBAL.CCY_CODE WHEN STBRN.BRANCH_LCY THEN
(Select Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN CR_BAL_LCY ELSE 0 END) - Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN 0 ELSE CR_BAL_LCY END)
FROM TEJPGLBL GLBAL1
Where GLBAL.BRANCH_CODE = GLBAL1.BRANCH_CODE
And GLBAL.GL_CODE = GLBAL1.GL_CODE and GLBAL.PERIOD_CODE = GLBAL1.PERIOD_CODE
and GLBAL.FIN_YEAR = GLBAL1.FIN_YEAR)
ELSE GLBAL.CR_BAL_LCY END))
WHEN 4 then
(Select Sum(CASE GLBAL.CCY_CODE WHEN STBRN.BRANCH_LCY
THEN (Select Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN CR_BAL_LCY ELSE 0 END) - Sum(CASE CCY_CODE WHEN STBRN.BRANCH_LCY THEN 0 ELSE CR_BAL_LCY END)
FROM TEJPGLBL GLBAL1
Where GLBAL.BRANCH_CODE = GLBAL1.BRANCH_CODE And GLBAL.GL_CODE = GLBAL1.GL_CODE and GLBAL.PERIOD_CODE = GLBAL1.PERIOD_CODE and GLBAL.FIN_YEAR = GLBAL1.FIN_YEAR)
ELSE GLBAL.CR_BAL_LCY END))
ELSE GLBAL.CR_BAL_LCY END)LCY_CREDIT, */
Sum(GLBAL.DR_BAL) FCY_DEBIT,
Sum(GLBAL.CR_BAL) FCY_CREDIT,
TEJPGLMA_LEAF.CATEGORY
FROM
TEJPGLMA TEJPGLMA_LEAF,
TEJPGLMA TEJPGLMA_PARENT,
TEJPGLMA TEJPGLMA_ULTPARENT,
TEJPGLBL GLBAL,
TEJPBRNH STBRN
WHERE TEJPGLMA_LEAF.PARENT_GL = TEJPGLMA_PARENT.GL_CODE
AND TEJPGLMA_LEAF.ULTI_PARENT = TEJPGLMA_ULTPARENT.GL_CODE
AND GLBAL.GL_CODE = TEJPGLMA_LEAF.GL_CODE
AND GLBAL.LEAF = 'Y'
AND GLBAL.BRANCH_CODE = STBRN.BRANCH_CODE
AND GLBAL.PERIOD_CODE = STBRN.CURRENT_PERIOD
GROUP BY
TEJPGLMA_LEAF.GL_CODE, TEJPGLMA_LEAF.GL_DESC ,
TEJPGLMA_LEAF.LEAF, TEJPGLMA_LEAF.PARENT_GL, TEJPGLMA_LEAF.ULTI_PARENT,
TEJPGLMA_PARENT.GL_DESC, TEJPGLMA_ULTPARENT.GL_DESC, GLBAL.CCY_CODE,
TEJPGLMA_LEAF.CATEGORY
Any help Appreciated..
Thanks,
Sandeep
October 31, 2011 at 7:29 am
It is nearly impossible to decipher all that unformatted code. The issue most likely somewhere in that overly complicated "nested case sub select thing" in the middle.
As a side note you really should be using current join syntax instead of the legacy style joins.
If you really want to get some assistance you need to post some ddl at the very least we can help figure out the syntax. Not too many people around here want to play sql compiler.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply