USE tempdb;
SET NOCOUNT ON;
GO

----
---- !!! Skor spusti - 0) 3b_Search_RandTab.sql - kvoli CREATE TABLE randTab
----				 - 1) !!!??? skry pred ocami riadok s WHERE TAJNY FILTER DU
----				 - 2) 2)3) [UN]COMMENT => no/drop index- 660
----				 - 3) NONCLUSTERED => index		- 3-6
----				 - 4)    CLUSTERED => index		- 3-6

---- 1)
IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'in_rand_date')  -- 500
	DROP INDEX in_rand_date ON randTab

---- 2)
--IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = 'in_rand_date') -- 30
--	CREATE NONCLUSTERED INDEX [in_rand_date] ON randTab(rand_date)

---- 3)
--IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = 'in_rand_date')
--	CREATE CLUSTERED INDEX [in_rand_date] ON randTab(rand_date)

DECLARE @beg datetime, @end datetime, @dtm datetime;
DECLARE @i INT;
SET @i = 0;

set @beg = GETDATE();

SELECT * FROM randTab 
																										WHERE rand_date < (SELECT MIN(rand_date) FROM randTab)  -- <=> CAST('2003.09.1' AS DATETIME)
--																	WHERE rand_date = '2003.09.1'  -- <=> CAST('2003.09.1' AS DATETIME)
----																	--WHERE rand_date > '2003.09.1'  -- <=> CAST('2003.09.1' AS DATETIME)
--																	WHERE rand_date IN ('1.1.1990','2.2.2000','1.1.2010','1.1.1980','2.2.2200','1.1.2011','1.2.1990','2.3.2000','3.1.2010')
--		ORDER BY rand_date DESC
--SELECT MIN(rand_date) FROM randTab 

set @end = GETDATE();

print DATEDIFF(MILLISECOND, @beg, @end)
RAISERROR( 'Toto nie je chyba, iba presmerovanie. Vidis? Nad ci pod 400?', 11, 1)