Case statement with multiple conditions in SQL Server

Question

Is it possible to combine this two into one cmpcategorycase when cmpcategory3939 OR cmpcategory IS NULL OR cmpcategory IS NOT NULL then duplcategory else cmpcategory end cmpcategorycase when cmpstatus1 and cmpstatus2 then duplcategory else cmpcategory end

pandeyism · Accepted Answer

Hi  chetanRefer below query according to query change your querySQLSELECT CustomerId  CASE WHEN CustomerId  1 OR CustomerId  2 AND CustomerId  3  THEN  39True39WHEN CustomerId  4 THEN 39False39ELSE 39Nothing39 END ResultFROM Customers

chetan · Answer

i got the solution SIr from ur reference  cmpcategorycase when cmpstatus2 and cmpcategory3939 OR cmpcategory IS NULL OR cmpcategory IS NOT NULL then duplcategory else cmpcategory endThis worked for me

Case statement with multiple conditions in SQL Server

Company

Explore

Follow us

Contact Us