I want a distinct list.

For the duplicate record you mentioned I only want to count it once (the first occurrence) because the first unit for the minimum startdate for the...

This drives me crazy as well.

To use DISTINCT COUNT the column must have a numeric data type. I don't understand why, I just know it is the only...