I have a new laptop (yes, laptop) running WIN7 64-bit with both SQL 2008 Enterprize and a SQLExpress install.

Both the 2008 instance and the SQLEXPRESS install returned the getdate() function...

Very interesting on the elapsed times... I would have figured I would have been the quickest without having to perform a table join, but I guess either the partition...

Nice ideas - I work in the insurance industry and use this often to look for out-of-sequence endorsements and transactions. Here's another way to acheive it, without a join.

select...