How to use CASE in SQL , Syntax Error being shown
- by Shantanu Gupta
I am trying to retrieve some records from table based on my query but it shows me an error
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '
select vd.LedgerId,(CreditAmt-DebitAmt) AS NET, CASE NET
WHEN NET > 0 THEN 'Debit' WHEN NET < 0 THEN 'Credit' ELSE 'Nil'End
from dbo.vdebit vd INNER JOIN dbo.vCredit vc ON vd.LedgerId=vc.LedgerId