I need to be able to separate words in a sentence and insert them as their own record. For example, I have a record that needs inserted:
I need 6 records to be inserted from the above 3 records (note the IDs)
Any help or direction on this would be greatly appreciated. I'm actually trying to achieve this in SSIS, but figured I could also do it in SQL as well.