Loading

Incorrect Yntax near AS

anil john

14y1.5k

Plz help me to rectify the error:

Error: Incorrect syntax near the keyword 'As'.

Code:

declare @flag as int;
SET @flag='1';
SELECT Ci.iInstNumber AS InstNo,Ci.dInstDate AS InstDate, CASE WHEN (@flag='1')THEN SUM(Ci.fInstAmount+Ci.fShareProfit) ELSE Ci.fInstAmount As InstAmount END

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shivanand Arur14y ago
Hello Anil, please remove the 'as' keyword you have written after the declare @flag statement...

Code:

declare @flag int;
SET @flag='1';
SELECT Ci.iInstNumber AS InstNo,Ci.dInstDate AS InstDate, CASE WHEN (@flag='1')THEN SUM(Ci.fInstAmount+Ci.fShareProfit) ELSE Ci.fInstAmount As InstAmount END

Anil please mark the answer as accepted, if it helped!!!
Thank you.