This is an example script from my toolkit that helps me to quickly review the various different ways of performing date math in sql server.
Demo available here
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.