معالجة التكرار في البيانات

السلام عليكم ورحمة الله وبركاته :

هذا مثال لحضرتك من الألف إلى الياء .. شبيه تماماً كما تريد ..

Create Table MyTable(id int , name nvarchar(50))
GO

Insert MyTable Select 1,'S'
Insert MyTable Select 1,'S'
Insert MyTable Select 1,'S'

Insert MyTable Select 2,'Q'
Insert MyTable Select 2,'Q'
Insert MyTable Select 2,'Q'
Insert MyTable Select 2,'Q'
Insert MyTable Select 2,'Q'

Insert MyTable Select 3,'A'
Insert MyTable Select 3,'A'
Insert MyTable Select 3,'A'
Insert MyTable Select 3,'A'

Insert MyTable Select 4,'V'
Insert MyTable Select 4,'V'
Insert MyTable Select 4,'V'
Insert MyTable Select 4,'V'

Insert MyTable Select 5,'aa'

Insert MyTable Select 6,'nn'

GO

سنقوم بالعملية التالية للتخلص من التكرار ..

Declare @id int , @name Nvarchar(50) , @count bigint

Declare C Cursor For 
		Select  id , name From MyTable 
		group by id, name
		having count(*) > 1

Open C
Fetch Next From C Into @id , @name

While @@fetch_Status = 0
begin

		Select @count = Count_big(*) From MyTable Where id = @id And name = @name
		Set @count = @count - 1

		Set  Rowcount @count
		Delete From MyTable Where id = @id And name = @name
		Set  Rowcount 0

		Fetch Next From C Into @id , @name
end

Close C
DeAllocate C

شوف النتائج

Select * From MyTable

بالتوفيق ..