SQLServerCentral: Content tagged T-SQL, ROW

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 | 23,944 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...

By John Ryle 2011/10/18 | Source: SQLServerCentral.com | Category: common table expressions

Rating:

|

Discuss |

Briefcase | 5,229 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,349 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 2010/10/11 | Source: SQLServerCentral.com | Category: cte

Rating:

|

Discuss |

Briefcase | 5,152 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 | 23,944 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,197 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,229 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,116 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 | 67,913 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,349 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 | 67,913 reads

Content with tags T-SQL, ROW_NUMBER()