Hi Ray, just a quick comment on your response - your final query will, in fact, only return those orders that are placed at the same millisecond as the query is run.
The time portion of getdate() needs to be stripped out before it will work as you suggest.
Also, curdate() and date() are not standard SQL Server functions.
Regards
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.