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 …