CREATE TABLE Data
(
	DataID uniqueidentifier NOT NULL,
	TVID uniqueidentifier NOT NULL,
	TypeDataID uniqueidentifier NOT NULL,
	dtMeasure datetime NOT NULL,
	Value1 float NULL,
	Value2 float NULL,
	Value3 flaot NULL,
	Value4 float NULL,
	Value5 float NULL,
	..................
	Value495 float NULL,
	Value496 float NULL,
	Value497 float NULL,
	Value498 float NULL,
	Value499 float NULL,
	Value500 float NULL,
	DeleteStateCode int NOT NULL,
	
	CONSTRAINT PK_Data PRIMARY KEY CLUSTERED
	(
		DataID ASC
	)
	WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX TVIndex ON Data
(
	TVID ASC,
	TypeDataID ASC,
	dtMeasure ASC
)
WHERE (DeleteStateCode = 0)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

SELECT dtMeasure, Value1, Value2, Value10, Value50
FROM Data
WHERE TVID = '00000000-0000-0000-0000-000000000000' AND
      TypeDataID = '00000000-0000-0000-0000-000000000000' AND
      dtMeasure BETWEEN '01.10.2015' AND '31.10.2015' AND
      DeleteStateCode = 0