That doesn't handle people that arrive before 8/1/05 and depart before, on, or after 8/10/05. I'm pretty sure my previous post does the trick. If you find a hole in...

Feel pretty stupid answering my own question, but I think this does the trick if anyone else is interested.

DepDate >= '8/1/04' AND ArrDate =< '8/10/04'

And people arriving after 8/1 and leaving before 8/10.

That's what I meant by brute force. I was hoping for a cleaner solution. I know I've seen it done before with...