Mike,

Not BIG on DBA, but the only question I have with your code:

SELECT ...

FROM ...

WHERE COALESCE(DateTo, Today) >= Today

is, if DateTo is an indexed column, wouldn't wrapping it in COALESCE()...

So, when you boil all this down, how do you handle things like DateTerminated, DisconnectDate (specifically DATETIME datatypes) when the event has not occurred. You know that an employee will...