Asi te sirve?
Código sql:
Ver originalDECLARE @temp TABLE(tabla VARCHAR(255), columna VARCHAR(255))
INSERT INTO @temp
SELECT T.TABLE_NAME, C.column_name
FROM information_schema.TABLES T
INNER JOIN information_schema.COLUMNS C ON T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_NAME NOT LIKE 'sys%'
AND T.TABLE_NAME <> 'dtproperties'
AND T.table_schema <> 'INFORMATION_SCHEMA'
AND C.column_name LIKE '%mes%'
AND T.TABLE_NAME NOT LIKE 'VX%'
AND T.TABLE_NAME NOT LIKE 'XX%'
AND T.TABLE_NAME NOT LIKE 'zz%'
ORDER BY T.TABLE_NAME, C.TABLE_NAME
SELECT 'SELECT * FROM '+tabla+' WHERE '+columna+' = 12' FROM @temp