ROW_NUMBER

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.

How to Compare Rows within Partitioned Sets to Find Overlapping Dates

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates

Eliminating Duplicate Rows using The PARTITION BY clause

The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.

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

Generating a Distinct Delimited List Using XML

Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.

Paging and Versioning Using ROW_NUMBER()

Paging through results of data, or finding specific sets of data is something that most of us need to do. A new article from Lawrence Moore shows us how we can do this with ROW_NUMBER()

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.

Managing Large Data Sets in SQL Server 2005 and 2008

Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.

ROW_NUMBER(): An efficient alternative to subqueries – Scenario 2

Introduction In the first article I discussed how the ROW_NUMBER() function can cut down resources spent on queries dealing with versioning. In this article I will discuss how the ROW_NUMBER() function can help when dealing with range requirements. The code samples are available for download. The name of the file is RowCountScenario2-CodeDownload.sql. Scenario 2 – […]