Sep 30, 2009 07:17 PM|Emtucifor|LINK
I can tell you right now that the CTE in Cetin's link will not perform as well as my UDF. Also, use of a permanent numbers (tally) table performs better than one created on the fly.
I do apologize for the bug in my query to not respect the delimiter passed in! It is fixed now in the original thread.