WEB LISTING 2: Batch That Duplicates the Northwind Orders Table 20 Times
SET NO COUNT ON

DECLARE @Counter int
SET @counter = 1

WHILE @Counter <=20
BEGIN	
	
	INSERT INTO BigOrders
	(
	OrderID    
	,CustomerID
	,EmployeeID 
	,OrderDate                                             
	,RequiredDate                                          
	,ShippedDate                                           
	,ShipVia    
	,Freight              
	,ShipName                                
	,ShipAddress                                                 
	,ShipCity       
	,ShipRegion     
	,ShipPostalCode
	,ShipCountry    
	)
	SELECT     
	orderID    
	,CustomerID
	,EmployeeID 
	,OrderDate                                             
	,RequiredDate                                          
	,ShippedDate                                           
	,ShipVia    
	,Freight              
	,ShipName                                
	,ShipAddress                                                 
	,ShipCity       
	,ShipRegion     
	,ShipPostalCode
	,ShipCountry    
	FROM
		orders

	SET @counter = @counter + 1
END