My favorite technique for generating test data is cross joining temp tables. Cross joins return results where every member of one table is combined with every member of another table.

By...