IMSports-ETL icon indicating copy to clipboard operation
IMSports-ETL copied to clipboard

Which version of AdventureWorks does this work with? 2017 2012 etc.

Open foral66 opened this issue 6 years ago • 0 comments

Which version of AdventureWorks does this work with? 2017 2012 etc. i.e. file Stg_DimCustomer.sql has statement

INSERT INTO ##tempCustomer SELECT Sales.Client.CustomerID, Sales.Client.PersonID, People.PersonDetails.DemographicInfo, Sales.Client.StoreID, Sales.Store.Demographics FROM Sales.Client LEFT JOIN People.PersonDetails ON People.PersonDetails.BusinessEntityID = Sales.Client.PersonID LEFT JOIN Sales.Store ON Sales.Store.BusinessEntityID = Sales.Client.StoreID ;

I can not find a table or view called Sales.Client in any version of AdventureWorks that I can find ..

foral66 avatar Nov 27 '18 23:11 foral66