SQL 2012 – Generate Calendar with Cross joins

“cross join” is a difficult to explain to trainees.  The mechanics aren’t very complicated.  However, the question is where you would ever use them? One example that I came up with is generating a calendar.  Let’s say I want to generate a list of dates in a set of years.  For example, I want a …

SQL 2012 – Generate Calendar with Cross joins Read More »