Re: SQL 2000 dies on JOIN query

Giganews Newsgroups
Subject: Re: SQL 2000 dies on JOIN query
Posted by:  Alexander Kuznetsov (AK_TIREDOFSP…@hotmail.COM)
Date: 22 Aug 2006

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,'')

Replies

None

In response to

SQL 2000 dies on JOIN query posted by Martini on Tue, 22 Aug 2006