InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:50:01 GMT20http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxNo. Sorry, the example is just pseudo-code, you'll have to replace some stuff to make it actually work. I put the '...' there in case you wanted to add more variables than just @ID ("FETCH NEXT INTO @ID, @Whatever, @Something). You could use the other variable in whatever processing you need to run, or if the primary key on that table is multiple columns you'd need to grab all of them just to delete.Tue, 07 Apr 2009 14:03:18 GMTerik-507089http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxSo the "..." after the "@ID" is not needed?I do understand the basics of variables, but am still learning how to use them properly.Thanks TedTue, 07 Apr 2009 13:39:19 GMTtlocke-512364http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxNo problem. Anything with an @ in front is a variable. @ID would hold a value for each row of the table that somehow uniquely identifies that row. So, the cursor has you looping through all the duplicate values. Each time it gets to "Fetch Next Into @ID", it puts the next value into the variable.Then, the first time through the loop, it assigns that to @KeepID. And any subsequent loops, you would run all your logic to merge / move / delete the duplicate record.Tue, 07 Apr 2009 13:36:05 GMTerik-507089http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxSorry I am still a newbie when it comes to programming like this...What is the "@ID ..." signify. I figured out the ListOfFields but just can't figure out what the "@ID..." signifies. Thank YouTedTue, 07 Apr 2009 10:57:06 GMTtlocke-512364http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxI've found the easy way to remove duplicates is with the UNION statement:select * into aTempTablefrom SourceTableUNIONselect * from SourceTableGOtruncate table SourceTableinsert into SourceTableselect * from aTempTableGODoes this work for you?Wed, 07 Jan 2009 07:51:03 GMTjnichols-797753http://www.sqlservercentral.com/Forums/Topic626371-1442-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/duplicate+records/65381/">Handle Duplicate Records</A>[/B]Sun, 28 Dec 2008 18:33:51 GMTerik-507089