Posted by rhaazy on 07/03/06 14:09

> There are two problems with NOT IN, that NOT EXISTS does not have:
>
> 1) you can get lost when there are NULL values involved.
> 2) works only with one-column conditions.


Well luckily for me it is unacceptible for GUIID to be null and that is
the only column I need to have a condition for.

• Next in forum: How to move transaction logs on-line?
• Prev in forum: Re: multiple rows and columns MAX
• Thread view: Re: Update statement, then insert what wasn't available to be updated.

[Reply to this message]