SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Arrays Rss

Search for any content tagged arrays

   Items 1 to 3 of 3   

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,392 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,828 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,174 reads
   Items 1 to 3 of 3