Home

Rule description

• Related IF/ELSE IF statements and WHEN clauses in a CASE should not have the same condition

Non-compliant Code Example

SELECT ProductNumber, Category =  
CASE ProductLine  
    WHEN 'R' THEN 'Road'  
    WHEN 'M' THEN 'Mountain'   --Non compliant code (When clauses is having similar condition)
    WHEN 'T' THEN 'Touring'  
    WHEN 'M' THEN 'Sale items'   --Non compliant code (When clauses is having similar condition)
    ELSE 'Not for sale'  
END,  
Name  
FROM Production.Product  
ORDER BY ProductNumber;

Compliant Code Example

SELECT ProductNumber, Category =    --Compliant code (When clauses is having different condition)
CASE ProductLine
    WHEN 'R' THEN 'Road'
    WHEN 'M' THEN 'Mountain'
    WHEN 'T' THEN 'Touring'
    WHEN 'S' THEN 'Sale items'
    ELSE 'Not for sale'
END,
Name
FROM Production.Product
ORDER BY ProductNumber;