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

Content with tag row_number Rss

   Items 1 to 7 of 7   
 

GetNumsAB

A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.  Read more...
By Alan Burstein 2016/04/19 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 534 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,260 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,408 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,260 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,408 reads

Convert Row to Column without using any other column for Pivot

Aim is to convert Row output having 3 rows of column Text to column output having 3 columns named as say Text1, Text2, Text3, without using any other column  Read more...
By ashish verma 2013/07/29 | Source: SQLServerCentral.com | Category: pivot
Rating: (not yet rated) |  Discuss |   Briefcase | 858 reads

Convert Row to Column without using any other column for Pivot

Aim is to convert Row output having 3 rows of column Text to column output having 3 columns named as say Text1, Text2, Text3, without using any other column  Read more...
By ashish verma 2013/07/29 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 2,289 reads
   Items 1 to 7 of 7   
 
Tags
convert row to column (2)    
pivot (2)    
t-sql (2)    
duplicate data (1)    
itzik ben-gan (1)    
modulo (1)    
nasty fast (1)    
numbers (1)    
numbers function (1)    
over (1)    
rbar (1)    
rows to columns (1)    
set based (1)    
tally table (1)