Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag row_number Rss

Search for any content tagged row_number

   Items 1 to 6 of 6   
 

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.  Read more...
By Mike McQuillan 2016/11/08 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 3,286 reads

Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.   Read more...
By Mike McQuillan 2016/10/17 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 2,039 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2015/12/11 (first published: 2014/07/17) | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,313 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 29,438 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2015/12/11 (first published: 2014/07/17) | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,313 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 29,438 reads
   Items 1 to 6 of 6