Collect all words from mssql tables colums10.06.20

-- not work yet
DROP TABLE #_allwords

DECLARE @tmp table(descr varchar(400))

INSERT INTO @tmp
SELECT DISTINCT  av0_description AS [description]
FROM [SL].[dbo].[av0_style]
WHERE av0_not_to_sale = '0'
AND av0_metal NOT IN('PK')
AND av0_not_active = '0'
AND av0_finding = '0'
AND F34_av0_a = '0'
AND av0_exlusive_item = '0'
AND av0_group NOT IN('CA','M','MT','PT','RU','SRV','PIC','STK')
AND av0_Group2 NOT IN('CA','M','MT','PT','RU','SRV','PIC','STK')
UNION
SELECT DISTINCT av21_Description AS [description]
FROM [SL].[dbo].[av21_kode_for_style]

UPDATE @tmp
SET descr = replace(descr, '.', '')

DECLARE @xml xml
SET @xml = '<c>' + replace(
    (SELECT ' ' + descr
    FROM @tmp
    for xml path('')
), ' ', '</c><c>') + '</c>'

SELECT section.Cols.value('.', 'varchar(250)') words
 INTO #_allwords
 FROM @xml.nodes('/c') section(Cols)

INSERT INTO sl_h.dbo.words(word)

SELECT words
FROM #_allwords

LEFT JOIN sl.dbo.av0_style as s
ON words = s.av0_style

WHERE ltrim(rtrim(words)) <> ''
AND  s.av0_style IS NULL 
AND words LIKE '[a-zA-Z]%'
AND LEN(words) > 3
AND NOT EXISTS (SELECT word FROM sl_h.dbo.words)
group by words

https://stackoverflow.com/questions/106275/how-to-get-a-distinct-list-of-words-used-in-all-field-records-using-ms-sql

Anonymous

Collect all words from mssql tables colums10.06.20

Information Epoch 1773178319