CREATE DATABASE ___SampleDbForTesting___1
GO
USE ___SampleDbForTesting___1
GO
CREATE TABLE ___SampleDbForTesting___1.dbo.Table_1 (
symbol NVARCHAR(255) NULL,
xdate DATETIME2(0) NULL,
price FLOAT NULL
) ON [PRIMARY]
GO
--Insert data in Table_1
SET DATEFORMAT ymd
SET ARITHABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS, XACT_ABORT OFF
GO
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-07 00:00:00.0000000', N'DLF', 142.65)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-07 00:00:00.0000000', N'UNITECH', 19.35)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-08 00:00:00.0000000', N'DLF', 149.9)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-08 00:00:00.0000000', N'UNITECH', 19.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-09 00:00:00.0000000', N'DLF', 153.45)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-09 00:00:00.0000000', N'UNITECH', 20.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-10 00:00:00.0000000', N'UNITECH', 19.35)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-10 00:00:00.0000000', N'DLF', 153.1)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-13 00:00:00.0000000', N'DLF', 147.45)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-13 00:00:00.0000000', N'UNITECH', 18.55)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-14 00:00:00.0000000', N'DLF', 105.5)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-14 00:00:00.0000000', N'UNITECH', 18.1)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-16 00:00:00.0000000', N'DLF', 110.6)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-16 00:00:00.0000000', N'UNITECH', 17.4)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-17 00:00:00.0000000', N'DLF', 111.2)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-17 00:00:00.0000000', N'UNITECH', 17.65)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-20 00:00:00.0000000', N'DLF', 115.45)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-20 00:00:00.0000000', N'UNITECH', 17.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-21 00:00:00.0000000', N'DLF', 121.5)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-21 00:00:00.0000000', N'UNITECH', 17.65)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-22 00:00:00.0000000', N'DLF', 120.4)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-22 00:00:00.0000000', N'UNITECH', 17.6)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-23 00:00:00.0000000', N'DLF', 119.95)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-23 00:00:00.0000000', N'UNITECH', 17.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-27 00:00:00.0000000', N'DLF', 110.8)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-27 00:00:00.0000000', N'UNITECH', 17.15)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-28 00:00:00.0000000', N'DLF', 111.65)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-28 00:00:00.0000000', N'UNITECH', 17.2)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-29 00:00:00.0000000', N'DLF', 118.45)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-29 00:00:00.0000000', N'UNITECH', 17.8)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-30 00:00:00.0000000', N'DLF', 124.85)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-30 00:00:00.0000000', N'UNITECH', 19.45)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-31 00:00:00.0000000', N'DLF', 125.25)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-10-31 00:00:00.0000000', N'UNITECH', 20.55)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-03 00:00:00.0000000', N'DLF', 128.8)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-03 00:00:00.0000000', N'UNITECH', 22.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-05 00:00:00.0000000', N'DLF', 127.1)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-05 00:00:00.0000000', N'UNITECH', 22.6)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-07 00:00:00.0000000', N'DLF', 134.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-07 00:00:00.0000000', N'UNITECH', 22.75)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-10 00:00:00.0000000', N'DLF', 135.95)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-10 00:00:00.0000000', N'UNITECH', 21.65)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-11 00:00:00.0000000', N'DLF', 137.4)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-11 00:00:00.0000000', N'UNITECH', 21.7)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-12 00:00:00.0000000', N'DLF', 140.05)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-12 00:00:00.0000000', N'UNITECH', 21.15)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-13 00:00:00.0000000', N'DLF', 139.15)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-13 00:00:00.0000000', N'UNITECH', 19.95)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-14 00:00:00.0000000', N'DLF', 142.25)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-14 00:00:00.0000000', N'UNITECH', 21)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-17 00:00:00.0000000', N'DLF', 140.1)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-17 00:00:00.0000000', N'UNITECH', 20.75)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-18 00:00:00.0000000', N'DLF', 139.1)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-18 00:00:00.0000000', N'UNITECH', 20.6)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-19 00:00:00.0000000', N'DLF', 141.35)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-19 00:00:00.0000000', N'UNITECH', 19.85)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-20 00:00:00.0000000', N'DLF', 138.5)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-20 00:00:00.0000000', N'UNITECH', 19.05)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-21 00:00:00.0000000', N'DLF', 140.75)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-21 00:00:00.0000000', N'UNITECH', 19.3)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-24 00:00:00.0000000', N'DLF', 147.35)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-24 00:00:00.0000000', N'UNITECH', 19.8)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-25 00:00:00.0000000', N'DLF', 141.75)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-25 00:00:00.0000000', N'UNITECH', 18.2)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-26 00:00:00.0000000', N'DLF', 152.15)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-26 00:00:00.0000000', N'UNITECH', 19)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-27 00:00:00.0000000', N'DLF', 148.95)
INSERT [Table_1] (xdate, symbol, price)
VALUES ('2014-11-27 00:00:00.0000000', N'UNITECH', 19.55)
GO
--Now see data in Table_1
SELECT
*
FROM Table_1
GO
|