TSQL Challenge 18 - Logic Testing Sandbox (Czech)
Tue, 03/23/2010 - 14:02 — 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
With Czech language settings.
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 CZECH
SET DATEFIRST 2
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'| ÚNOR 1900 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| ŘÍJEN 1959 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| LEDEN 1975 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| KVĚTEN 1987 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| ÚNOR 2000 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| ZÁŘÍ 2008 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| SRPEN 2009 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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'| ÚNOR 2015 |' UNION ALL
SELECT N'|=============================|' UNION ALL
SELECT N'| ned pon úte stř čtv pát sob |' 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
