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?

Microsoft SQL Server 2008

Last Comment

Guy Hengel [angelIII / a3]

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Lee

6/29/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Jim Horn

6/29/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

HKFuey

6/29/2012

ASKER

Both work, thanks for SUPERFAST response!

Guy Hengel [angelIII / a3]

6/29/2012

the syntax is correct, but the SQL Managment studio SQL editor is not smart enough to allow the CASE constructs, unfortunately :(

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

Certified Expert Program

Credly Partnership

Udemy Partnership