• As I'm leaving for the day and don't have time to create a more robust example, try this on Northwind. Ten bucks says you get the same results...If you don't agree, I'll create another example for you tomorrow.

    select * from orders where OrderId in

    (select distinct orderid from orders where orderdate >convert(datetime, '07/03/1996', 103)

    and orderdate <= convert(datetime, '07/08/1996', 103) + 1)

    select * from orders where orderdate >convert(datetime, '07/03/1996', 103) and orderdate <= convert(datetime, '07/08/1996', 103) + 1

    -- You can't be late until you show up.