1
Vote

Wrong StateProvinces

description

The following query against the adventure works 2014 database reveals, that the german city "München" seems to be located in 4 different states (Hessen, Nordrhein-Westfalen, Saarland and the city-state Hamburg), none of them is the correct one.
München is located in Bayern.

select city,a.StateProvinceID,Name
from person.Address a
left join person.StateProvince sp
on a.StateProvinceID=sp.StateProvinceID
where city='münchen'
group by city,a.StateProvinceID,name

i found this very confusing when Walking through the Analysis Services tutorial. I thought I made misstakes in cofiguring the cube.

comments