quote:

---

Originally posted by richard75013

Pick up a book called learn TSQL in 21 days, its a really, really good book for beginners, you'll like it and there are many examples in it. There’s a whole lot more than just learning how to write an SP when it comes to good optimization and recompiling.

---

--CREATE PROCEDURE sp_RemoveDups
--AS
--Begin

	Declare  @ID	varchar(11),
		 @Bad	varchar(8),
		 @Good	varchar(8),
		 @BadID varchar(8)

--Create temptable


--GO

IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
      WHERE TABLE_NAME = 'temp_RemoveDups')

DROP TABLE temp_RemoveDups 

--GO

CREATE TABLE temp_RemoveDups 
	([ID] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL )
ON [PRIMARY]

--Add new Data to table.  This Data is the ID of the duplicates in the Db.Tbl
INSERT INTO temp_RemoveDups 

SELECT ID--, count(Fld) 
FROM Tbl
WHERE ID  in (
SELECT Fld
FROM db..tbl --change to db for production
GROUP BY Fld
HAVING count(tbl_id) = 1)
GROUP BY ID
HAVING count(Fld) > 1

--Declare a cursor
DECLARE temp_RemoveDups_cursor CURSOR

--   FOR SELECT ID FROM temp_RemoveDups WHERE ID IN ( 'Item','item')
 	FOR SELECT ID FROM temp_RemoveDups

OPEN temp_RemoveDups_cursor
	
	FETCH temp_RemoveDups_cursor INTO
		@Id	

	WHILE @@FETCH_STATUS = 0
	BEGIN

set @Good  = (SELECT this FROM db..tbl WHERE fld = @ID)

--Place the code for looping the recordset
		DECLARE MoreThanOne Cursor FOR
			SELECT Fld 
			FROM Tbl 
			WHERE ID = @ID AND Fld <> @Good
			ORDER BY Fld 
		
		OPEN MoreThanOne
		FETCH MoreThanOne INTO 
			@BadID
		
			WHILE @@Fetch_STATUS = 0
			BEGIN
				set @Bad = @BadID
			
			END
		
		--Change/Switch the numbers

		EXEC ghpsp_change_Fld @Bad, @Good	
		
		FETCH MoreThanOne INTO 
			@BadID

		End
		Close MoreThanOne
		Deallocate MoreThanOne

--set @Bad = (SELECT Fld FROM Tbl WHERE ID = @ID AND Fld <> @Good)


FETCH temp_RemoveDups_cursor INTO
		@ID	

	--END
	CLOSE temp_RemoveDups_cursor
	DEALLOCATE temp_RemoveDups_cursor
--END

--GO