Phil Parkin (8/4/2015)
Thanks for doing a proper analysis :blush:
I just found myself with a spare few minutes whilst trying to reproduce a customer issue in-house 😉
reddychaitanyakrishna (8/4/2015)
Hi Buddy,I tried your query but i'm getting Syntax error as
Incorrect syntax near the keyword 'IN'.
Please help on this.
Well then, you didn't try "my" query then since I commented out the "CASE IN" section with the comment "ENTIRELY INCORRECT".
Let's take a look at it. . .
CASE
F234.TECH_TRAN_TYPE IN ('CRB','CRD','CPB','CPB')
WHEN SUM(POST.POST_BASE_AMT) 'Underwriter O/S',
That makes no syntactical sense.
At a total guess, did you mean something like: -
CASE WHEN F234.TECH_TRAN_TYPE IN ( 'CRB', 'CRD', 'CPB', 'CPB' )
THEN SUM(POST.POST_BASE_AMT)
ELSE 0
END 'Underwriter O/S'
??