Hi Team,

Above T-SQL code is exactly resolved my requirement, but i've two database tables (@replacements, @theStrings), how to use the below code with actual tables.

WITH rep AS (

SELECT string_id, theString AS OriginalString, REPLACE(theString, old, new) AS replacedString,

id

FROM @theStrings t

CROSS JOIN @replacements r

WHERE id = 1

UNION ALL

SELECT r.string_id, r.OriginalString, REPLACE(replacedString, old, new) AS replacedString,

rl.id

FROM @replacements rl

INNER JOIN rep AS r

ON rl.id = r.id + 1

)

SELECT OriginalString, replacedString

FROM (

SELECT OriginalString, replacedString, rn = ROW_NUMBER() OVER (PARTITION BY string_id ORDER BY id DESC)

FROM rep

) AS data

WHERE rn = 1;