SELECT p.id as id, m.target as target_value,count(*) as number_selected
FROM .dbo.uf_generated_profile_table() p LEFT OUTER JOIN t_mine_relations m
ON
(p.column1 is null or
(left(p.column1,2) = '==' and
substring(p.column1,4,len(p.column1)-3) = m.column1) or
(left(p.column1,2) = '!=' and
substring(p.column1,4,len(p.column1)-3) != m.column1)
) and
... { similar clauses for all t_mine_relations columns ... columnN}
GROUP BY id, m.target
Example 2: Generation evaluator in implemented in standard SQL.
Back to Article