>BTW, why did you pick up such an ugly function?
>
>Why not
>
>http://sqlblog.com/blogs/aaron_bertrand/archive/2010/07/07/splitting-a-list-of-integers-another-roundup.aspx
>
>or
>
>http://www.sqlservercentral.com/articles/Tally+Table/72993/
>

First hit on Google. I didn't even look at the code to decide if it's beautiful or not. I just need something that works.