Hi all,
I have a table where Primary key has been vanished and the table has multiple entries for the each row, i mean every single row is having n no. of entry in table. now i want to delete all the duplicate entries while keeping atleast one entry for each row. Can anyone suggest me query or solution for the same. The table is some what like ......
menu_id menu_name menu_icon
001 Master master.ico
002 Home home.ico
003 Banquet banquet.ico
001 Master master.ico002
002 Home home.ico
003 Banquet banquet.ico
001 Master master.ico
002 Home home.ico
003 Banquet banquet.ico

you would have to select distinct records from your table into new table and, if necessary clean up your original table and insert records back.

Jaime E. Maccou

http://www.sql-server-performance.co...duplicates.asp -- Is an excellent article on this subject. It has examples with with working samples.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com