SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

declare @json as nvarchar(max) = N'[
    {
        "timestamp": 1679424324000,
        "SENSORNAME": "DEM-Checkme 1607",
        "uuid": "4FRA001",
        "PULSE": "99",
        "SPO2": "0",
        "PI": "0.00",
        "DIA": "0",
        "SYS": "0",
        "TEMP": "0.0",
        "HR": "99",
        "ECGWAVE": [
            -52,
            -51,
            -50,
            -48,
            -47,
            -46,
            -46,
            -46,
            -46,
            -45,
            -44,
            -41,
            -38,
            -33,
            -28,
            -22,
            -16,
            -11,
            -7,
            -6,
            -5,
            -7,
            -10,
            -14,
            -19,
            -25,
            -31,
            -35,
            -39,
            -40,
            -42,
            -41,
            -40,
            -37,
            -35,
            -32,
            -30
        ],
        "QRS": "74",
        "QTC": "272",
        "QT": "224",
        "ST": "-2"
    }
    
]';

SELECT
  timestamp,
  SENSORNAME,
  uuid,
  PULSE,
  SPO2,
  PI,
  DIA,
  SYS,
  TEMP,
  HR,
  QRS,
  QTC,
  QT,
  ST,
  j2.value AS ECGWAVE_value
FROM OPENJSON(@json)
  WITH (
    timestamp bigint,
    SENSORNAME varchar(100),
    uuid varchar(30),
    PULSE decimal(18,9),
    SPO2 decimal(18,9),
    PI decimal(18,9),
    DIA decimal(18,9),
    SYS decimal(18,9),
    TEMP decimal(18,9),
    HR decimal(18,9),
    ECGWAVE nvarchar(MAX) AS JSON,
    QRS decimal(18,9),
    QTC decimal(18,9),
    QT decimal(18,9),
    ST decimal(18,9)
  ) j1
CROSS APPLY OPENJSON(j1.ECGWAVE) j2;

timestamp	SENSORNAME	uuid	PULSE	HR	QRS	QTC	QT	ST	ECGWAVE_value
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-52
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-51
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-50
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-48
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-47
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-46
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-46
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-46
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-46
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-45
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-44
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-41
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-38
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-33
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-28
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-22
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-16
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-11
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-7
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-6
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-5
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-7
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-10
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-14
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-19
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-25
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-31
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-35
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-39
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-40
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-42
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-41
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-40
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-37
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-35
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-32
1679424324000	DEM-Checkme 1607	4FRA001	99.000000000	99.000000000	74.000000000	272.000000000	224.000000000	-2.000000000	-30