TSQL Challenge 18 - Logic Testing Sandbox (English)
Tue, 03/23/2010 - 13:49 — jacob
Use the following TSQL template to test your solutions against the tricky date for TSQL Challenge 18
/***********************************************************************
----------------------------------------------
LOGIC Testing Sandbox for TSQL Challenge 18
Copyright © beyondrelational.com
----------------------------------------------
Notes:
1. Copy this template and paste in your SSMS Query editor
2. Insert your query (solution for TSQL Challenge 18)
in the Section between "Insert your query below"
and "Insert your query above"
3. Run the whole batch. If you see
"Invalid Results...Failed!" getting printed in output
window, there is something wrong in the query.
Revision History:
Rev 00 - 23 March 2010 - Jacob Sebastian - Initial Release
***********************************************************************/
/*
Create a wrapper procedure around the solution
*/
IF OBJECT_ID('tempdb..#TestSolution') IS NOT NULL BEGIN
DROP PROCEDURE #TestSolution
END
GO
CREATE PROCEDURE #TestSolution AS
BEGIN
DECLARE @T TABLE (MTH INT, YR INT)
INSERT @T SELECT 8,2009
UNION ALL SELECT 2,1900
UNION ALL SELECT 2,2015
UNION ALL SELECT 2,2000
UNION ALL SELECT 10,1959
UNION ALL SELECT 9,2008
UNION ALL SELECT 1,1975
UNION ALL SELECT 5,1987
;
/* Insert your query below */
/* Insert your query above */
END
GO
SET NOCOUNT ON
/*
Start the testing phase
*/
SET LANGUAGE ENGLISH;
SET DATEFIRST 4;
DECLARE @x TABLE(
AutoID INT IDENTITY,
Calendar NVARCHAR(31)
)
-- Execute the code and
INSERT @x EXEC #TestSolution
DECLARE @z TABLE(
AutoID INT IDENTITY,
Calendar NVARCHAR(31)
)
INSERT INTO @z(Calendar)
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| FEBRUARY 1900 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 |' UNION ALL
SELECT N'| 4 5 6 7 8 9 10 |' UNION ALL
SELECT N'| 11 12 13 14 15 16 17 |' UNION ALL
SELECT N'| 18 19 20 21 22 23 24 |' UNION ALL
SELECT N'| 25 26 27 28 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| OCTOBER 1959 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 |' UNION ALL
SELECT N'| 4 5 6 7 8 9 10 |' UNION ALL
SELECT N'| 11 12 13 14 15 16 17 |' UNION ALL
SELECT N'| 18 19 20 21 22 23 24 |' UNION ALL
SELECT N'| 25 26 27 28 29 30 31 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| JANUARY 1975 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 4 |' UNION ALL
SELECT N'| 5 6 7 8 9 10 11 |' UNION ALL
SELECT N'| 12 13 14 15 16 17 18 |' UNION ALL
SELECT N'| 19 20 21 22 23 24 25 |' UNION ALL
SELECT N'| 26 27 28 29 30 31 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| MAY 1987 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 |' UNION ALL
SELECT N'| 3 4 5 6 7 8 9 |' UNION ALL
SELECT N'| 10 11 12 13 14 15 16 |' UNION ALL
SELECT N'| 17 18 19 20 21 22 23 |' UNION ALL
SELECT N'| 24 25 26 27 28 29 30 |' UNION ALL
SELECT N'| 31 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| FEBRUARY 2000 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 4 5 |' UNION ALL
SELECT N'| 6 7 8 9 10 11 12 |' UNION ALL
SELECT N'| 13 14 15 16 17 18 19 |' UNION ALL
SELECT N'| 20 21 22 23 24 25 26 |' UNION ALL
SELECT N'| 27 28 29 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| SEPTEMBER 2008 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 4 5 6 |' UNION ALL
SELECT N'| 7 8 9 10 11 12 13 |' UNION ALL
SELECT N'| 14 15 16 17 18 19 20 |' UNION ALL
SELECT N'| 21 22 23 24 25 26 27 |' UNION ALL
SELECT N'| 28 29 30 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| AUGUST 2009 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 |' UNION ALL
SELECT N'| 2 3 4 5 6 7 8 |' UNION ALL
SELECT N'| 9 10 11 12 13 14 15 |' UNION ALL
SELECT N'| 16 17 18 19 20 21 22 |' UNION ALL
SELECT N'| 23 24 25 26 27 28 29 |' UNION ALL
SELECT N'| 30 31 |' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'+-----------------------------+' UNION ALL
SELECT N'| FEBRUARY 2015 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| Sun Mon Tue Wed Thu Fri Sat |' UNION ALL
SELECT N'|-----------------------------|' UNION ALL
SELECT N'| 1 2 3 4 5 6 7 |' UNION ALL
SELECT N'| 8 9 10 11 12 13 14 |' UNION ALL
SELECT N'| 15 16 17 18 19 20 21 |' UNION ALL
SELECT N'| 22 23 24 25 26 27 28 |' UNION ALL
SELECT N'+-----------------------------+'
-- Match the output with expected result.
IF EXISTS(
(SELECT * FROM @x EXCEPT SELECT * FROM @z)
UNION ALL
(SELECT * FROM @z EXCEPT SELECT * FROM @x))
BEGIN
PRINT 'Invalid Results...Failed!'
END ELSE BEGIN
PRINT 'Congratulations...Passed!'
END
Subscribe
