---- Vytvori tabulku 1 milion nahodnych datumov.
---- Create a table with 1 hundred thousend
---- 0) 3b_Search_RandTab.sql - tento dokument
---- 1) 3c_Search.sql - dalsi dokument

SET NOCOUNT ON;

USE tempdb;
GO

------
------ 1) Nahodna tabulka:
------
IF OBJECT_ID('dbo.randTab', 'U') IS NOT NULL DROP TABLE dbo.randTab;
GO

CREATE TABLE randTab (
  id INT,
  rand_date DATETIME
);
GO

print RAND(19983)

DECLARE @i INT;
SET @i = 0;
--WHILE @i < 50000 
WHILE @i < 1000000 -- !!? trva asi 30 sec.

BEGIN
   SET @i = @i + 1;
   INSERT INTO randTab VALUES (
      @i,
      CONVERT(DATETIME, 365*101+25 +  2001*RAND())
   )
END

SELECT TOP 5 * FROM randTab;
GO

select count(*) from randTab