Solution to remove duples from SQL table

remove_duples.sql

-- Stupid solution to remove duples from sql table...

DECLARE @temp TABLE 
( 
    [Col1] [uniqueidentifier] NOT NULL,
    [Col2] [uniqueidentifier] NOT NULL
)

INSERT INTO @temp 
	SELECT DISTINCT [Col1] ,[Col2]
	FROM TargetTable

DELETE FROM TargetTable

INSERT INTO TargetTable SELECT * FROM @temp