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 http://stackoverflow.com/questions/219716/what-are-the-uses-for-cross-join … in fact, it even makes a good business name http://www.crossjoin.co.uk/ … 🙂 Here is a basic example of how a cross join works using userid’s and dates.