Create Tally table and generate 100 million numbers. Change the CROSS JOIN part to limit the number of values generated. CREATE TABLE [Tally] ( [N] [INT] NOT NULL PRIMARY KEY ) GO ;WITH cte(N) AS ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) a (n) CROSS JOIN (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))…