T-SQL Arrays

Here's a good link compiling various methods for processing information in an array-like method.
http://www.projectdmx.com/tsql/sqlarrays.aspx