Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2008 View Syntax

I have this: -

CASE WHEN ISNULL(dbo.View_StockCapture_Total.Qty)THEN 0 ELSE dbo.View_StockCapture_Total.Qty END

I get message "unable to parse expression"

Group By option enabled

Can anyone help?
ASKER CERTIFIED SOLUTION
Avatar of Lee
Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HKFuey

ASKER

Both work, thanks for SUPERFAST response!
the syntax is correct, but the SQL Managment studio SQL editor is not smart enough to allow the CASE constructs, unfortunately :(