Andy Riley

Using Ranking Functions to Deduplicate Data

This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(100)

You rated this post out of 5. Change rating

2010-07-27

14,176 reads

Every organization I talk to has the same problem dressed up in different clothes....

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Comments posted to this topic are about the item The day-to-day pressures of a...

Comments posted to this topic are about the item The Problem Isn't Always Your...

Comments posted to this topic are about the item Identity Defaults

What happens when I run this code?

CREATE TABLE dbo.IdentityTest
(
     id int IDENTITY(10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO