TheSQLGuru (10/15/2010)
I consider Erland's guideance on this topic to be an excellent resource: http://www.sommarskog.se/arrays-in-sql.html
+1. Erland's treatment of this topic is extremely detailed, and covers each version of SQLS from 2000 through 2008.