Hello,
my scenario is, I have a table (lets call it replace_tab) where I store a string in each record. So it is a very simple table with 1 column for the string (with a primary key on that column). The table has around 50 - 100 records.
And there is a second table (sentence_tab) with about 1 milllon records. Each record has a sentence in the sentence_col column.
Now I need to remove (replace) all the strings from the replace_tab in each record in the sentence_tab from the sentence_col value. I can do this with CTE, but I fear that would take too much time. Anyone got a faster solution besides dynamic SQL with nested replaces ?
sql_coder