Generating data the Itzik Ben Gan way..
Select Union All as a cartesion product. I normally create for example a set of 4mrd records and use the numeric values to add columns and generate data based on the value. I often use modulo (%) to narrow down…