please solve this problem

phanimadhav

Hi friends this is my select statement

SELECT user_accountID,Expensive = case quotaAmount
when quotaNo = 'quota1' then sum(quotaAmount) else 0 end
FROM user_accounts

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '='.

whenever i am executing the query this error will be occur please clear this error
i am newone of this sqlserver.I did not understand this problem.Please clarify my doubt

OuTCasT

Expand|Select|Wrap|Line Numbers

 SELECT user_accountID,Expensives,SUM(quotaAmount) FROM user_accounts WHERE quotaNo = 'quota1' Group by user_accountID
 

BHTanna

Can you just tell, what are you exactly trying do?

What do you want to achieve?

Delerna

You are getting the error because you have the syntax of the case statement wrong

This

Expand|Select|Wrap|Line Numbers

 
SELECT user_accountID,

   CASE when quotaNo = 'quota1' 

   THEN sum(quotaAmount) 

   ELSE 0 end as Expensive

FROM user_accounts

group by user_accountID

might be how you meant it but I can't tell.
What BHTanna requests might prove helpfull.

please solve this problem

re: please solve this problem

re: please solve this problem

re: please solve this problem

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about