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

Content with tag Arrays Rss

   Items 1 to 8 of 8   
 

Arrays in SQL that Avoid Repeated Groups

It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.  Read more...
By Joe Celko 2011/07/20 | Source: SimpleTalk | Category: arrays
Rating:  Rate this |   Briefcase | 3,141 reads

The Multi-valued Parameters problem in Reporting Services

Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.  Read more...
Rating: |  Discuss |   Briefcase | 13,527 reads

Faking Multidimensional Arrays in T-SQL made easy!

Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!  Read more...
By Randal Burke 2008/11/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,066 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,134 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,075 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,589 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,003 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,272 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (6)    
advanced querying (5)    
counter (5)    
delimited strings (5)    
development (5)    
nums (5)    
parse (5)    
sql server 2005 (5)    
sqlinsider scripts (5)    
string manipulation (5)    
table of numbers (5)    
tally (5)    
sql server 7 (3)    
2-dimensional arrays (2)    
data manipulation (1)    
repeated groups (1)    
reporting services (ssrs) (1)    
stored procedures (1)