Incidentally, if you're using SQL 2005, you can jump straight to the final result fairly elegantly |
Glad to see that someone finally figured out that there are 30 minutes between 12:30 and 13:00 and not just 29... Nicely done, Ryan.
--Jeff Moden
Change is inevitable... Change for the better is not.