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

Probably the best piece of advice I ever received is to take time to...

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Comments posted to this topic are about the item Automating OSM Data Refresh in...

Comments posted to this topic are about the item Database Mail Configuration

Comments posted to this topic are about the item Learn From History

If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?