TSQL Tuesday 87 Parsing JSON Pre 2016

JSON Parse 2014.sql

SELECT 
	NAME, 
	StringValue, 
	ValueType
FROM 
(
	SELECT 
		[NAME], 
		StringValue, 
		ValueType, 
		LAG([NAME],1,0) OVER (ORDER BY  element_id, sequenceNo, parent_ID) as PreviousKey 
	FROM 
		Sandbox.dbo.parseJSON(@WebsiteJson) -- This is Phil Factor's JSON parsing function: https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/
)d 
WHERE 
	PreviousKey <> 'id' 
	and [NAME] = 'name'