CREATE TABLE [dbo].[YP_CRT_Data_4Hours] ( [CRTD_ID] INT 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 );