How to fix this SQL Server error?

user9925928

My query throws an error

Incorrect syntax near '='.

Please tell me where I am doing wrong.

case 
   when proj.country_name = 'UK' 
      then proj.region = 'NE'
   when proj.Country_Name = 'Belgium' or proj.Country_Name = 'Germany' or proj.Country_Name = 'Netherlands' 
      then proj.region = 'CE'
   when proj.Country_Name = 'Spain' or proj.Country_Name = 'France' or proj.Country_Name = 'Italy' 
      then proj.region = 'SE'
   else proj.region
end as Region_NCC,

Thanks

Yogesh Sharma

That is invalid syntax case expression doesn't return value with column name :

case when proj.country_name = 'UK' then 'NE'
     when proj.Country_Name in ('Belgium', 'Germany', 'Netherlands') then 'CE'
     when proj.Country_Name in ('Spain','France', 'Italy') then 'SE' 
     else proj.region
end as Region_NCC

I have used IN clause instead of strange OR clause.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-05-2

Comments

0 comments

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

How to fix SQL server JSON_VALUE path has '-' error

how to fix sql server page level corruption?

How to fix this SQL Server error?

How to fix this SQL Server error?

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

How to import an asset in swift using Bundle.main.path() in a react-native native module

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

pump.io port in URL

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

BigQuery - concatenate ignoring NULL

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Do Idle Snowflake Connections Use Cloud Services Credits?

maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

Generate random UUIDv4 with Elm

Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?

flutter: dropdown item programmatically unselect problem

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

EXCEL: Find sum of values in one column with criteria from other column

Pandas - check if dataframe has negative value in any column

How to use merge windows unallocated space into Ubuntu using GParted?

Make a B+ Tree concurrent thread safe

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements