SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorksDW2008R2;Data Source=.;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=FRED;Use Encryption for Data=False;Tag with column collation when possible=False];

SQL SELECT * FROM AdventureWorksDW2008R2.dbo.FactInternetSales;

OrderDate:
SQL SELECT 	
         DateKey              AS OrderDateKey
       , FullDateAlternateKey AS OrderDate
       , CalendarYear         AS OrderYear
       , EnglishMonthName     AS OrderMonth
       , MonthNumberOfYear    AS OrderMonthNumber
       , WeekNumberOfYear     AS OrderWeekNumber
   FROM AdventureWorksDW2008R2.dbo.DimDate;

ShipDate:
SQL SELECT 	
         DateKey              AS ShipDateKey
       , FullDateAlternateKey AS ShipDate
       , CalendarYear         AS ShipYear
       , EnglishMonthName     AS ShipMonth
       , MonthNumberOfYear    AS ShipMonthNumber
       , WeekNumberOfYear     AS ShipWeekNumber
   FROM AdventureWorksDW2008R2.dbo.DimDate;
   
SQL SELECT * FROM AdventureWorksDW2008R2.dbo.DimCurrency;
SQL SELECT * FROM AdventureWorksDW2008R2.dbo.DimCustomer;
SQL SELECT * FROM AdventureWorksDW2008R2.dbo.DimProduct;
SQL SELECT * FROM AdventureWorksDW2008R2.dbo.DimSalesTerritory;