Ars Technica

T-SQL question (for use in SSRS)

SELECT DISTINCT ContractNumber, AccountID WHERE ContractNumber IN ( (CASE WHEN @PorC = 'P' THEN (PNumber) ELSE (@TNumber) END) ) This works when @TNumber is a single value, but the parameter is ...