Deleting Duplicate Rows

				
--**************************************
-- Name: Deleting Duplicate Rows
-- Description:The Purpose of this code is to delete the duplicate values occuring in a table. This code is column-oriented. That means the code works for the duplicate values occuring in a specified column and deletes the values of the rows corresponding to that column.
-- By: barkýn ünüulu
--
-- Inputs:I am going to specify the column name as COLUMNNAME and table name as TABLENAME. It should be noted that the developers that are willing to run this code should put an "id" column in to their tables, which increments automatically.
--
-- Side Effects:As the row number increases, the time elapsed for the code increases...
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=936&lngWId=5--for details.--**************************************

declare @i int
declare @j int
declare @k int
set @k=(select count(*) from TABLENAME)
set @i=1
 while @i<=@k
 begin
set @j=@i+1
 while @j<=@k
 begin
 if ((select COLUMNNAME from TABLENAME where ID=@i)=
(select COLUMNNAME from TABLENAME where ID=@j))
begin
 delete from TABLENAME
 where ID=@j
end
 set @j=@j+1
end
set @i=@i+1
 end