GPO (11/17/2011)
There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN and LESS THAN.
I wonder what your opinion is on INTERSECT, EXCEPT, or Common Table Expressions?
One BETWEEN statement easier to read than two or more GREATER THAN and LESS THAN statements.