Thanks for everyone's suggestions.  I ended up going with the iterative method in the Arrays and Lists in SQL Server article.  It's working great as far as I can tell.

Sabrina