IMSports-ETL
IMSports-ETL copied to clipboard
Which version of AdventureWorks does this work with? 2017 2012 etc.
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 ..