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.
Emtucifor
Member
40 Points
11 Posts
Re: Insert multiple rows from sql statement?
Sep 30, 2009 06:17 PM|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.