create procedure up_generated_profile_Evaluator
as 
exec up_timing_start 'up_generated_profile_Evaluator' 
delete from t_value_results
insert t_value_results
select p.id as id, m.CARAVAN as target_value,count(*) as number_selected
from  .dbo.uf_generated_profile_table() p left outer join t_mine_relations m 
on 
(p.MOSTYPE is null or
(left(p.MOSTYPE,2) = '==' and 
   substring(p.MOSTYPE,4,len(p.MOSTYPE)-3) = m.MOSTYPE) or 
(left(p.MOSTYPE,2) = '!=' and 
   substring(p.MOSTYPE,4,len(p.MOSTYPE)-3) != m.MOSTYPE) 
) and 
(p.MAANTHUI is null or
(left(p.MAANTHUI,2) = '==' and 
   substring(p.MAANTHUI,4,len(p.MAANTHUI)-3) = m.MAANTHUI) or 
(left(p.MAANTHUI,2) = '!=' and 
   substring(p.MAANTHUI,4,len(p.MAANTHUI)-3) != m.MAANTHUI) 
) and 

/* similar statements removed to shorten listing

) and 
(p.ABYSTAND is null or
(left(p.ABYSTAND,2) = '==' and 
   substring(p.ABYSTAND,4,len(p.ABYSTAND)-3) = m.ABYSTAND) or 
(left(p.ABYSTAND,2) = '!=' and 
   substring(p.ABYSTAND,4,len(p.ABYSTAND)-3) != m.ABYSTAND) 
)
 group by id, m.CARAVAN
 order by id, m.CARAVAN
exec up_timing_end 'up_generated_profile_Evaluator'

GO
