Generate Large Amount of Data For Performance Testing

CREATE TABLE AllCustomerOrders(OrderID BigInt Primary Key,
CustomerID BigInt,
FirstName Varchar(100),
LastName Varchar(100),
ProductID Bigint,
UnitPrice Decimal(10,2),
OrderAmount Decimal(10,2),
OrderDate Datetime,
ShipDate Datetime)
GO

--INSERT RECORDS NOW
Declare @RowsRequired Bigint =100

;With CTE AS (
			Select Row_Number() Over (Order BY A.BusinessEntityID) CustomerID ,
				   A.FirstName ,
				   B.LastName 
			FROM person.person A CROSS JOIN person.person B)
INSERT INTO AllCustomerOrders(OrderID,CustomerID,FirstName,LastName,ProductID,UnitPrice,OrderAmount,OrderDate,ShipDate )
SELECT distinct OrderID,X.CustomerID,FirstName,LastName,ProductID,UnitPrice,OrderAmount,OrderDate,ShipDate 
FROM (SELECT Row_Number() Over (Order BY cAST(A.CustomerID AS BIGINT)) OrderID,A.*,SalesOrderID,ProductID,B.UnitPrice,LineTotal OrderAmount 
FROM CTE A CROSS JOIN   sales.salesOrderDetail B ) X
JOIN [Sales].[SalesOrderHeader] C ON C.SalesOrderID =X.SalesOrderID
WHERE OrderID<=@RowsRequired