By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @json NVARCHAR(MAX) = '
[
{
"resourceType": "virtualMachines",
"name": "Standard_E16-4as_v5",
"tier": "Standard",
"size": "E16-4as_v5",
"family": "standardEASv5Family",
"locations": ["SouthAfricaWest"],
"locationInfo": [
{
"location": "SouthAfricaWest",
"zones": [],
"zoneDetails": []
}
],
"capabilities": [
{
"name": "MaxResourceVolumeMB",
"value": "0"
},
{
"name": "vCPUs",
"value": "16"
}
],
"restrictions": []
},
{
"resourceType": "virtualMachines",
"name": "Standard_E15",
"tier": "Standard",
"size": "E15",
"family": "standardEASv5Family",
"locations": ["Africa"],
"locationInfo": [
| Name | vCPUs | MaxResourceVolumeMB |
|---|---|---|
| Standard_E15 | 18 | 25 |
| Standard_E16-4as_v5 | 16 | 0 |
Warning: Null value is eliminated by an aggregate or other SET operation.