Using Microsoft SQL 2008:
I have an SQL function that takes a string and splits it up into multiple values based on a delimiter. The function works like:
Here is an example:
The output is a table of values:
I would like to cycle through another table and split up a field in the table using the above function, and output a record for every split the function returns. For instance, if table1 contained the following records:
Then I would like to the following from this record:
Is there a simple way to do this using a with or some other method?