>>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.

Strange. Anyway, I suggest to better try something from the links I gave you or you can also look this long article by Erland Sommarskog (and he also shows how to do TVP as well)

http://www.sommarskog.se/arrays-in-sql.html

BTW, his TVP article is really great! I just glanced through the first part of it.