|
|
Posted by Alexander Kuznetsov on 08/22/06 14:32
Martini,
why do you want to do things like this? UDFs in WHERE clause are
usually performance killers. Isn't it simpler and faster to do just as
follows:
SELECT
a.person, v.code AS formula
FROM rows1 AS a
INNER JOIN rows2 v ON a.type=v.type
AND isnull(a.col1,'')=isnull(v.col2,'')
Navigation:
[Reply to this message]
|