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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback