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

Content with tags T-SQL, counter, nums Rss

   Items 1 to 7 of 7   
 

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,139 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,079 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,596 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,004 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,282 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 879 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 456 reads
   Items 1 to 7 of 7   
 
Tags
advanced querying (7)    
development (7)    
sqlinsider scripts (7)    
table of numbers (7)    
tally (7)    
sql server 2005 (6)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
sql server 7 (4)    
2-dimensional arrays (2)    
miscellaneous (2)    
table (2)