Mike, a WHILE loop is not the best way to split a CSV.

Take a look at this article. It explains how a table of numbers replaces a loop.

http://www.sqlservercentral.com/articles/TSQL/62867/