Cross Join to Generate Every Combination

Cross Joins are useful in Business Intelligence where you want to perform a cartesian product on two sets of data.  Possible uses are discussed below … in fact, it even makes a good business name … 🙂 Here is a basic example of how a cross join works using userid’s and dates.