SQLServerCentral: Content tagged 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,996 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,235 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,355 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,159 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,996 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,213 reads

Generating a Distinct Delimited List Using XML

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

By Puja Shah 2010/06/29 | Source: SQLServerCentral.com | Category: for xml path

Rating:

|

Discuss |

Briefcase | 7,063 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,235 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,147 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,960 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,355 reads

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. Read more...

By Zach Mided 2010/01/04 | Source: SQLServerCentral.com | Category: large data sets

Rating:

|

Discuss |

Briefcase | 10,323 reads

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

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

Duplicate Records using SQLCMD

We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table. Read more...

By Renato Buda 2009/04/06 | Source: SQLServerCentral.com | Category: duplicates

Rating:

|

Discuss |

Briefcase | 9,215 reads

Custom Pagination in SQL Server 2005

Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function. Read more...

By Adam Haines 2009/01/06 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 9,724 reads

Content with tag ROW_NUMBER()