In the spirit of the post...instead of:<p>SELECT COUNT(DISTINCT(Some_Column))
FROM Some_Table<p>try:<p>SELECT COUNT(X.Some_Column)
FROM (
SELECT Some_Column
, MAX(Some_Other_Column_Which_Can_Be_Maxed) [MaxValue]
FROM Some_Table
GROUP BY Some_Column
) AS X