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/
Adventure Works 2008 - how to find store location
