In this SQL Server Quickie I'm talking about Cross Joins in SQL Server. You can find the scripts that were used for the demonstration here: https://www.sqlpassion.at/archive/2016/06/07/sql-server-quickie-36-cross-joins/
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.