The SQL "CASE" keyword is syntax-colored as a function call in the Query Analyzer, even when used within the context of a CASE/WHEN/ELSE/END clause such as the following:
SELECT
agyEPActCovered,
agyGroup,
agyAbbrev,
agyName,
SUM(v.vehCount) AS agyInv,
SUM(CASE WHEN v.vehExecFleetAbbrev = 'Y' THEN v.vehCount ELSE 0 END) AS agyEFInv,
SUM(CASE WHEN v.vehExecFleetAbbrev = 'N' THEN v.vehCount ELSE 0 END) AS agyNonEFInv1,
SUM(CASE WHEN v.vehExecFleetAbbrev <> 'Y' THEN v.vehCount ELSE 0 END) AS agyNonEFInv2,
SUM(
CASE
WHEN v.vehExecFleetAbbrev = 'Y' THEN
CASE
WHEN v.vehAFV = 'Yes' AND (v.vehLayoutType = 'LSVs' OR (v.vehLayoutType = 'Sedans' AND v.vehLayoutSize IN ('Subcompact','Compact','Midsize'))) THEN v.vehCount
ELSE 0
END
ELSE 0
END
) AS agyEFCompliant,
SUM(
CASE
WHEN v.vehExecFleetAbbrev = 'Y' THEN
CASE
WHEN v.vehAFV = 'Yes' AND (v.vehLayoutType = 'LSVs' OR (v.vehLayoutType = 'Sedans' AND v.vehLayoutSize IN ('Subcompact','Compact','Midsize'))) THEN 0
ELSE v.vehCount
END
ELSE 0
END
) AS agyEFNoncompliant
FROM
usv_EPAct_Vehicles AS v
WHERE 0 = 0
AND v.dataYear = 2011
AND v.agyID NOT IN (1,2,2393)
AND v.vehRowType = 'Inventory'
AND v.vehDataType = 'Actual'
GROUP BY
agyEPActCovered,
agyGroup,
agyAbbrev,
agyName
Here is a patch with a fix:
Patch: http://dd1.aquafold.com/download/v10.0.0/ads-10.0.2_01-patch.zip
Update Instructions: http://www.aquafold.com/support-update.html