Sean Lange (8/20/2014)
BTW, You should not get into the habit of things like getdate() - 1. You should be explicit and use dateadd.
Heh... or just dump the newer date/time datatypes so that you can take these types of wonderful shortcuts. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.