chetan.deshpande001 (2/6/2014)
Would it be ok for you to use recursive CTE ? ..something like--Edit
I'm sorry for the formatting/colors ..as this is my first post and do not know how to post with SQL formatting being intact
OK ... perhaps, but the proposed Delimited8KSplit solution will outperform it, I'd bet my wife's shoes on that.
Out of interest, how did you get 329 points here without posting anything?
T-SQL formatting: All you need to do is enclose your code with {code="sql"}{/code} tags (use square brackets)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.