Everyday we are dealing with dates. Daily reports, monthly sales, annual projections, etc. Here are few tips how to get dates you want from a Microsoft SQL Database (tested on SQL 2005 Server).