Extract and Generate table with one

[qslx101]

Extract and Generate table with one word per record

Hello!
I need help!

Table A is populated with frases in each record. I wish to generate table B with all words from table A, but each word must be inserted in new line of table B. This should be done for all records of table A.

Is there a way to do that ?

I appreciate any help. Thank you very much.

 

[JamesJKusch]

What about duplicate words that may be created in TableB. Meaning if one record in TableA has the phrase "Some Like It Hot" and another record has the phrase "Hot Potatoe". Parsing the records from TableA would produce 2 records in TableB with the word "Hot".

Besides that issue, yes you can get this task accomplished by using a loop, ie. WHILE operation, with the use of the verbs SUBSTRING and probably PATINDEX.


J. Kusch