This scenario explained above might sound unbelievable but at the time we experienced this problem we felt mystified also. We have had three separate SQL persons (each one averaging 15...

Select col_a

from some_table t

join

(Select Top 1 date

 from (select date from from tableA where id = host_id()

        union all

       select getdate()) Q

 order by date desc) H on ...

The Getdate() Function is replacing the entire select staement when it returns a null. The isnull function first examines the result of the select statement and if the result returned...