CREATE TABLE [dbo].[DimensionDate](
	[DimDateKey] [int] NOT NULL,
	[CalendarDate] [datetime] NOT NULL

 CONSTRAINT [PK_Dim_Date] PRIMARY KEY CLUSTERED 
(
	[DimDateKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[stgDimensionDate](
	[DimDateKey] [int] NOT NULL) ON PRIMARY

CREATE TABLE [dbo].[DimensionDate](
	[DimDateKey] [int] NOT NULL,
	Sumitup bigint NOT NULL

 CONSTRAINT [PK_Dim_Date] PRIMARY KEY CLUSTERED 
(
	[DimDateKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



CREATE TABLE [dbo].[stgTestTable](
	[DimDateKey] [int] NOT NULL,
	Sumitup [bigint] NOT NULL
) ON [PRIMARY]

GO
declare @intLoop int = 0
WHILE @intLoop < 101
BEGIN
	SET @intLoop = @intLoop + 1
	INSERT INTO DimensionDate
	VALUES( CONVERT(VARCHAR(8),GETDATE()+@intLoop,112), CAST(150 +@intLoop AS BIGINT)) 
END
GO

exec xp_cmdshell @Query=N'BCP "SELECT [DimDateKey], SUM(Sumitup) AS Sumitup FROM dbo.DimensionDate WHERE DimDateKey >= 20100701 GROUP BY dimdatekey" queryout "c:\what_is_up.dat" -N -T -S{Your_server_name} -o "c:\what_is_up.out"',@NoOutput=N'No_Output'
BULK INSERT dbo.stgTestTable FROM "c:\what_is_up.dat" WITH (DATAFILETYPE ='widenative',TABLOCK,BATCHSIZE=512000)

DROP TABLE [dbo].[DimensionDate]
DROP TABLE [dbo].[stgTestTable]