ricky70rana (7/2/2010)
Actually you are right that i want to understand how that code is working.Only was able to understand Common Table Expression out of this script. Actually I want to understand how the CASE Statement is working. Do you have an idea about that?I already gone through with your script and that is less cumbersome than this one and easy to understand. Your post is good help to understand tally table and delimiters.
Without copying the code, reformating it to a more readable style for myself, then working through it, no I really don't. It is overly obfusicated when there are much easier ways of accomplishing the necessary task of a delimited split.
If you really want to understand the code, take the time to reformat the code so that you can understand the flow, then work through it like a computer would.