Posted on 2011-04-19
I have table T1 with a production stages .
The values allowed are (A1, B1, C1, D1, E1).
I have a query that counts the records based on those stages.
However, A1 and B1 are for same Title.
Is it possible to count either one of those or boths as one record
So if if i have A1 it will be counted 1
if i have B1 it will be counted 1
if i have both A1 and B1 they will be coutned 1.
would you create a derived column and sum on that.