sqlrambling.net
Shredding JSON Nested Arrays
Whilst reading up on SQL Server 2016 JSON functionality I have seen many examples of extracting data from a JSON array. However, I wanted to work out how to extract data from an array within an arr…