Very simple question that for some reason has me stumped. I would really like to look at all store demographics and sales by salesperson. I can't find a store address table or any relationship pertaining to a store address.
All of the addresses in AdventureWorks2008 OLTP are in Person.Address. The store table is joined through Person.BusinessEntity and Person.BusinessEntityAddress to get the Person.Address records associated with a store.
The VSD, PNG and JPG diagrams included are designed to fit an 11"x17" sheet printed, but you can probably get more mileage out of them digitally.
David Reed - MSFT - Microsoft Certified Architect|SQL Server - http://blogs.msdn.com/reedme/
Microsoft réalise une enquête en ligne pour comprendre votre opinion sur le site Web de Msdn. Si vous choisissez de participer, l’enquête en ligne vous sera présentée lorsque vous quitterez le site Web de Msdn.
Adventure Works 2008 - how to find store location
