Hello Ladies & Gentlemen I was wondering if someone knew of an easy way to remove duplicate entries from a SQL 2000 table? Any assistance would be greatly appreciated Thanks in advance pharoah35
See http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1093 http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1095 HTH. Gaurav Moderator Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Also see: http://www.sql-server-performance.com/rd_delete_duplicates.asp ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com