Database Challenges

The following script generates the data required for the performance testing of TSQL Challenge 26.

/*************************************************************
 --------------------------------------------------------------
 Performance Testing Data for TSQL Challenge 26
 Copyright © beyondrelational.com
 -------------------------------------------------------------- 
  
 Revision History:
 Rev 00 - 22 July 2010 - Khyati Patel - Initial Release     
*************************************************************/

IF OBJECT_ID('TC26_TrainingInfo','U') IS NOT NULL BEGIN
    DROP TABLE TC26_TrainingInfo
END
	
CREATE TABLE TC26_TrainingInfo(
	TrainingID INT IDENTITY,
	Training VARCHAR(20),
	ClassRoom VARCHAR(20),
	StartTime CHAR(5),
	Duration CHAR(5),
	Wk CHAR(2)
 )

;WITH TrainingInfo(Training, ClassRoom, StartTime, Duration, Wk) AS(
   SELECT 'SQL Server','Silver-Room','10:00','02:00','M' 
   UNION ALL
   SELECT 'SQL Server','Silver-Room','10:00','02:00','W' 
   UNION ALL
   SELECT 'SQL Server','Silver-Room','10:00','02:00','T' 
   UNION ALL
   SELECT 'SQL Server','Silver-Room','10:00','02:00','F' 
   UNION ALL
   SELECT 'ASP.NET','Cloud-Room','11:00','01:45','F' 
   UNION ALL
   SELECT 'ASP.NET','Cloud-Room','11:00','01:45','M' 
   UNION ALL
   SELECT 'ASP.NET','Cloud-Room','11:00','01:45','TH' 
   UNION ALL
   SELECT 'ORACLE','Gold-Room','11:00','03:20','TH'  
   UNION ALL
   SELECT 'ORACLE','Gold-Room','11:00','03:20','M'  
   UNION ALL
   SELECT 'ORACLE','Gold-Room','11:00','03:20','T'  
   UNION ALL
   SELECT 'ORACLE','Gold-Room','11:00','03:20','W'  
   UNION ALL
   SELECT 'ORACLE','Gold-Room','11:00','03:20','F'  
   UNION ALL
   SELECT 'ASP.NET','Gold-Room','16:02','01:47','F' 
   UNION ALL
   SELECT 'ASP.NET','Gold-Room','16:02','01:47','M' 
   UNION ALL
   SELECT 'ASP.NET','Gold-Room','16:02','01:47','TH')
INSERT INTO TC26_TrainingInfo (Training,ClassRoom,StartTime,Duration,Wk)
SELECT Training + CONVERT(VARCHAR, N) AS Training,  
	  ClassRoom + CONVERT(VARCHAR, N) AS ClassRoom,
	  StartTime,
	  Duration,
	  Wk
FROM TrainingInfo  
CROSS JOIN tsqlc_tally WHERE  N BETWEEN 1 AND 667   
;