A fun and different way to SELECT DISTINCT.

WITH DistinctCTE

AS (

SELECT [Column] = MIN(t.[Column])

FROM dbo.[Table] T

UNION ALL

SELECT R.[Column]

FROM (

SELECT T.[Column],

rn = ROW_NUMBER() OVER (ORDER BY T.[Column])

FROM dbo.[Table] T

JOIN DistinctCTE R

ON R.[Column] < T.[Column]

) R

WHERE R.rn = 1

)

SELECT *

FROM DistinctCTE

OPTION (MAXRECURSION 0);