SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tags SQL Server 2005, Advanced Querying Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (7)     Table of Numbers (6)     Parsing (5)     Miscellaneous (2)    
counter (6)     tally (6)     String Manipulation (5)     games (1)    
Development (6)     T-SQL Aids (6)     SQL Server 2000 (3)     Puzzle (1)    
nums (6)     Arrays (5)     2-Dimensional Arrays (2)     Table (1)    
SQLInsider Scripts (6)     Delimited Strings (5)    

Search for any content tagged SQL Server 2005 & Advanced Querying

Add a script

   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/10/23 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 88 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 Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 17 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 Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 15 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...
Rating: (not yet rated) |  Discuss |  Briefcase | 42 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 Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 67 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...
Rating: (not yet rated) |  Discuss |  Briefcase | 42 reads

A Sudoku solution with set based T-SQL utilizing binary operators.

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2008/06/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,164 reads
   Items 1 to 7 of 7