SQLServerCentral.com Articles tagged Arrays

Arrays in SQL that Avoid Repeated Groups

Wed, 20 Jul 2011 06:00:00 UT

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.

The Multi-valued Parameters problem in Reporting Services

Tue, 21 Apr 2009 06:00:00 UT

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.

Faking Multidimensional Arrays in T-SQL made easy!

Tue, 04 Nov 2008 07:00:00 UT

Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!