Hello, terrance
May you explain this syntax?
I think it is very dangerous to transfer search condition in the WHERE clause,
because you can alter result of "LEFT JOIN" that becomes a pure JOIN.
FROM @WorkTable AS wt
LEFT JOIN @CalTable AS ct ON
wt.Work_Start <= ct.CalDate
WHERE
(
CASE
WHEN ct.CalDate <= wt.Work_End THEN 1
ELSE 0
END
) = 1