Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Keep only one of duplicate record

Author  Topic  abc Starting Member 48 Posts Posted - 2001-09-07 : 03:58:19 Hi all, I have a trouble need yours help I have a talbe with two fields like this: ContenID Content wuy13 hsf klfh sfk fhdsfs 732js kdgksj klfj kfj kfj 33r8s kdj kdlj fkgjd kl wuy13 djkl lkjdfs 900ik kdg l;fkf kgj 732js kdgksj klfj kfj kfj 773nb kfdg dkfjf fkgsd 732js kdgksj klfj kfj kfj I want to remove all duplicate contentID, just keep only one record of that contentID. It mean that after remove my table will be: ContenID Content wuy13 hsf klfh sfk fhdsfs 732js kdgksj klfj kfj kfj 33r8s kdj kdlj fkgjd kl 900ik kdg l;fkf kgj 773nb kfdg dkfjf fkgsd Help me pls. Thanks Thanks