Connecting Excel to SQL Statements
Just as there are tables in SQL Server within our
AdventureWorks2014 database for us to query on, there are also predefined views that are available for us to use; for all practical purposes, these views behave exactly the same as tables. The views are available at the following location within SQL Server:
The following script can be used to pull store information such as postal codes and the number of employees:
SELECT StoreAddress.City as 'City' ,StoreAddress.Name as 'Store Name' ,StoreAddress.PostalCode as 'Postal Code' ,sum(StoreDemo.NumberEmployees) as 'Number of Employees' FROM [AdventureWorks2014].[Sales].[vStoreWithAddresses] ...