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

Content with tag row_number Rss

   Items 1 to 4 of 4   
 

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2014/07/17 | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 12,506 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Stefan Krzywicki 2013/10/08 | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 15,757 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 | 746 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,199 reads
   Items 1 to 4 of 4   
 
Tags
convert row to column (2)    
pivot (2)    
t-sql (2)    
duplicate data (1)    
modulo (1)    
over (1)    
rows to columns (1)