You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 ..
The text was updated successfully, but these errors were encountered:
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 ..
The text was updated successfully, but these errors were encountered: