I know it's an old post but I thought I'd provide an update just in case anyone is still thinking about using XML for splitting. Please see the following article...
http://www.sqlservercentral.com/articles/Tally+Table/72993/
If there were any doubt before, there isn't now. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.