Find and Remove Duplicate Records SQL Server
Learn a quick method to find and remove duplicate records in your SQL Server tables.
2016-02-01
9,306 reads
duplicate records
2009-01-07 (first published: 2008-12-26)
2,104 reads
Deleting Duplicate Records
This article explains a simple solution for the common problem in MSSQL 7.0/2000, finding & deleting duplicate records from a table.
2008-12-24 (first published: 2008-11-26)
2,806 reads
2011-06-13 (first published: 2008-04-19)
5,796 reads
RE: How do I query Self Referencing Tables
In 7 / 2000 you'll need a temporary table and a loop to get the full heirarchy. Infinite loops are great this way too.I believe 2005 can create a view with self referencing tables and it will populate the full heirarchy.
2004-09-10
6 reads
RE: Connection Reuse
Variable not in scope or not opened? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-09
1 reads
RE: Using "Like" or Wildcard
In addition to pulling all courses that are active, I would also like to pull all courses from the LEDef_Cd field that begins with the number 10.
2003-06-09
1 reads
RE: Dymanic database context change
You need to do something like this: declare @cmd nvarchar(4000) set @cmd = 'declare @db2 nvarchar(50)' + char(13) + 'use pubs' + char(13)+ 'set @db2 = db_name()' + char (13) + 'print @db2' --print @cmd exec (@cmd) Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-19
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers