By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Declare @JSON varchar(max) = '
{
"columns": [
"State",
"Honey producing colonies",
"Yield per colony",
"Production",
"Stocks December 15",
"Average price per pound",
"Value of production",
"Year"
],
"rows": [
[
"AL",
"41",
"20",
"820",
"33",
"0.54",
"443",
"1989"
],
[
"AZ",
"78",
"45",
"3510",
"1158",
"0.55",
"1931",
"1989"
]
]
}
'
| key | Pos1 | Pos2 | Pos3 | Pos4 | Pos5 | Pos6 | Pos7 | Pos8 |
|---|---|---|---|---|---|---|---|---|
| 0 | AL | 41 | 20 | 820 | 33 | 0.54 | 443 | 1989 |
| 1 | AZ | 78 | 45 | 3510 | 1158 | 0.55 | 1931 | 1989 |