Select customer data from the SQL Server Adventure Works database to demonstrate saving returned data to a CSV file.

customer_location_csv.sql

-- File:		customer_location_csv.sql
-- Date:		March 31, 2022
-- Author:		Randy Runtsch
-- Description:	Get the names and location (city, state or province, 
--				postal code, and country or region name
--				for all customers in the AdventureWorks2019 database.
--				Return the data in plain text format.

USE AdventureWorks2019;

GO

SELECT  

	-- TOP (5)
		
		BusinessEntityID
	,	City
	,	StateProvinceName
	,	PostalCode
	,	CountryRegionName

	FROM [AdventureWorks2019].[Sales].[vIndividualCustomer]

	ORDER BY 
  
			CountryRegionName
		,	StateProvinceName
		,	City;

GO