I have a case statement in my sql
case when [SSS] In ('34','33') And [ST]='y' then [TT]*[TS] else (case when([SSP] Is Not Null And [ST]='y' then [PT]*[TSS] else 0) end AS STT,
I am getting an error reading:
Incorrect syntax near the keyword 'then'.
I have tried to fix it but i am not sure what the problem is