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,157 reads

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...

If it fails where you thought it would fail that is not a failure....

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Comments posted to this topic are about the item Don't Create Workslop

Comments posted to this topic are about the item What is the original database...

Comments posted to this topic are about the item The DBScan algorithm tutorial

What is returned when this code is run?

SELECT ORIGINAL_DB_NAME()