select name
from sys.tables with (nolock)
where name like '%tastewiseIdTable_MFR207%' and name like '%search%'
and name like '%raw%'
and create_date >=
No Searches to Patch
No Data To Load
select tw_id as search_id
from qmd_excelData
union
select tastewise_parent_id as search_id
from qmd_excelData
where tastewise_parent_id is not null and tastewise_parent_id <> ''
truncate table #_tableName#
insert into #_tableName# (search_id)
values (
)
Data Loaded into Tastewise Search #encodeforHtml( _tableName )#