'Change Where Clause Values Based on Parameter

I have the query below that returns results based on the company and job entered by the user. I have a request to modify this query so that it will use CostType IN (10,41) for one company and CostType = 10 for all other companies. Is this possible?

SELECT
    *
FROM
    JCCH

WHERE
    CostType = 10
    AND Company = (@Company)
    AND Job = (@Job)
    AND Active = 'Y'
sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions