I'm writing a select statments witht ntext data type field. This select statment requires a Union operator. Since Sql Server 2005 gave me an error "The ntext data type cannot be selected as DISTINCT because it is not comparable", I have to change Union to Union All. When Union All is used, the statment works without error. However, it returns duplicate rows.
How do I eliminate these the duplicated rows from the select statment?