Excellent article and feedback.

I did find one point that I disagree with in rule #1:

Rule #1: Use NULLs to indicate unknown/missing information only. Do not use NULLs in place...

I use a combination of the following three methods:

SELECT SUM(CTR),[ID] FROM

(SELECT 1 AS CTR,* FROM Compare1

UNION

SELECT 1 AS CTR,* FROM Compare2) AS X

GROUP BY [ID]

HAVING SUM(CTR)>1

SELECT a.[ID]

FROM Compare1 AS...

ILAN,

There are a number of ways to do what I think you are trying to do. If you want a job to run if a date on any row in...

I tried the exact example that you described and got a unicode 132 back. Maybe more information would help. What is the string you are passing?