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

Content with tag tally Rss

   Items 1 to 13 of 13   
 

Calendar Table by Day

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/12 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 653 reads

Calendar Table by Year

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/11 | Source: SQLServerCentral.com | Category: reporting
Rating: (not yet rated) |  Discuss |   Briefcase | 848 reads

Calendar Table by Month

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/10 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 908 reads

Calendar Table by Interval Minutes

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/06 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 896 reads

Virtual tally table function

An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.  Read more...
By Steven Willis 2013/07/23 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,041 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...
By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 1,202 reads

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,122 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,065 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,577 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 | 997 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,251 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 | 877 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 | 452 reads
   Items 1 to 13 of 13   
 
Tags
advanced querying (8)    
counter (8)    
development (8)    
nums (8)    
sqlinsider scripts (8)    
table of numbers (8)    
t-sql (8)    
sql server 2005 (7)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
calendar (4)    
reporting (4)    
sql server 7 (4)    
miscellaneous (3)    
2-dimensional arrays (2)    
table (2)    
cte (1)    
cursor (1)    
loop (1)    
prime (1)    
prime number (1)    
sieve (1)    
while (1)