Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, ROW_NUMBER() Rss

   Items 1 to 12 of 12   
 

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  Read more...
By Kevin Wu 2013/12/25 (first published: 2010/10/11) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 6,929 reads

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.  Read more...
By Suresh Maganti 2012/03/02 (first published: 2010/09/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,474 reads

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.   Read more...
Rating: |  Discuss |   Briefcase | 5,385 reads

Search all columns in every table for a value

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...
By Michael Davis 2010/11/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,422 reads

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  Read more...
By Kevin Wu 2013/12/25 (first published: 2010/10/11) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 6,929 reads

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.  Read more...
By Suresh Maganti 2012/03/02 (first published: 2010/09/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,474 reads

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   Read more...
By Andy Riley 2010/07/27 | Source: SQLServerCentral.com | Category: deduplicate
Rating: |  Discuss |   Briefcase | 12,311 reads

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()  Read more...
By Lawrence Moore 2010/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,337 reads

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.  Read more...
By Wayne Sheffield 2010/04/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,534 reads

ROW_NUMBER(): An Efficient Alternative to Subqueries

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...
By Francis Rodrigues 2010/01/29 (first published: 2009/05/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 68,296 reads

Search all columns in every table for a value

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...
By Michael Davis 2010/11/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,422 reads

ROW_NUMBER(): An Efficient Alternative to Subqueries

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...
By Francis Rodrigues 2010/01/29 (first published: 2009/05/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 68,296 reads
   Items 1 to 12 of 12   
 
Tags
cte (3)    
common table expressions (cte) (1)    
date manipulation (1)    
deduplicate (1)    
dense_rank() (1)    
interstorm (1)    
michael davis (1)    
ntile (1)    
paging (1)    
partition by (1)    
partitioned sets (1)    
ranking (1)    
ranking functions (1)    
search (1)