DynamicSqlPart3.sql

-- Show what has been found
SELECT * FROM @meta
ORDER BY [value_found], [schema_name], [table_name], [column_name], [update_script]

-- Merge update queries to use some of them in a customization project
SELECT DISTINCT STRING_AGG(CAST([update_script] AS nvarchar(max)), ';' + CHAR(13) + CHAR(10)) AS UpdateQueries
FROM @meta

-- Merge delete queries to use some of them in a customization project
SELECT DISTINCT STRING_AGG(CAST([delete_script] AS nvarchar(max)), ';' + CHAR(13) + CHAR(10)) AS DeleteQueries
FROM @meta