Query data from SQL Server and write its results in the JSON format.

customer_location_json.sql

-- File:		customer_location_json.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 JSON format.

USE AdventureWorks2019;

GO

SELECT  

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

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

	ORDER BY 
  
			CountryRegionName
		,	StateProvinceName
		,	City
		
	FOR JSON PATH