CREATE TABLE [dbo].[TMP_CRT_Data_1Month] ( [CRTD_ID] INT IDENTITY (1, 1) NOT NULL, [CRTD_Period] DATETIME NOT NULL, [CRTD_FirstQuote] DATETIME NOT NULL, [CRTD_LastQuote] DATETIME NOT NULL, [CRTD_PairSymbol] VARCHAR (50) NOT NULL, [CRTD_BidOpeningValue] FLOAT (53) NOT NULL, [CRTD_BidClosingValue] FLOAT (53) NOT NULL, [CRTD_BidLowValue] FLOAT (53) NOT NULL, [CRTD_BidHighValue] FLOAT (53) NOT NULL, [CRTD_MidOpeningValue] FLOAT (53) NOT NULL, [CRTD_MidClosingValue] FLOAT (53) NOT NULL, [CRTD_MidLowValue] FLOAT (53) NOT NULL, [CRTD_MidHighValue] FLOAT (53) NOT NULL, [CRTD_DateIn] DATETIME NOT NULL );