SET NOCOUNT ON

IF OBJECT_ID('tempdb..#sample') IS NOT NULL DROP TABLE #sample
CREATE TABLE #sample (
	[SampleID] INT
	, [SampleValue] VARCHAR(16)
	)
	
INSERT #sample ([SampleID], [SampleValue])
SELECT
	CAST(CAST(NEWID() AS VARBINARY(16)) AS TINYINT)
	, CAST(CAST(NEWID() AS VARBINARY(16)) AS VARCHAR(16))
FROM
	sys.objects so

-- Show the problem
SELECT
	[SampleID]
	, COUNT([SampleValue]) AS [SampleIDCount]
FROM
	#sample
GROUP BY
	[SampleID]
	
	
	
-- New Table
IF OBJECT_ID('tempdb..#result') IS NOT NULL DROP TABLE #result
CREATE TABLE #result (
	[SampleID] INT IDENTITY(1,1)
	, [SampleValue] VARCHAR(16)
	, PRIMARY KEY ([SampleID])
	)
	
DECLARE @batchSize SMALLINT = 500
DECLARE @rows INT = 1
DECLARE @totalRows INT = ( SELECT COUNT(*) FROM #sample )
DECLARE @rowsGone INT = 0

WHILE @rows > 0
BEGIN

	INSERT #result ([sampleValue])
	SELECT d.[SampleValue]
	FROM (
		DELETE TOP (@batchSize) FROM #sample
		OUTPUT DELETED.[SampleValue]
		)
		AS d
	
	SET @rows = @@ROWCOUNT
	SET @rowsGone += @rows
	RAISERROR('Processed %i out of %i...', 0, 1, @rowsGone, @totalRows) WITH NOWAIT
END

-- Show the result
SELECT
	[SampleID]
	, COUNT([SampleValue]) AS [SampleIDCount]
FROM
	#sample
GROUP BY
	[SampleID]

quote:

---

Originally posted by SwePeso

This is how I would do it.

1. Get a list of duplicate values.
2. With this list, assign unique values to the duplicates.

---

N 56°04'39.26"
E 12°55'05.63"

---