Duplicates (distinct doesnt work)

[mymou]

Hi All

Need to delete some duplicates:

select distinct *
into #temp_table
from table_name

Doesn't work, as one of the columns has a text data type and distinct cannot be used on this data type.

My SQL isnt up to this. Help.


Stew

 

[mymou]

Beat you too it this time!!


select news_title, max(news_id) as news_id into #temp1
from news_data
group by news_title

select news_data.*
from news_data, #temp1
where #temp1.news_id = news_data.news_id

Just never thought about using an ID in an aggreggate function before.

Stew