Monthly Archives: August, 2008

The ntext data type cannot be selected as DISTINCT because it is not comparable

Hi All, Today, I again come up with a very interesting problem. I was working on an SQL Server 2005 DB with almost 160 tables. In one of the core table, there was a field with data type "NTEXT". I wanted to apply DISTINCT on it, as I was getting duplicated records against a join …

Continue reading