By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE SMARTMETER
(
METERNUM int,
READDATETME1 datetime,
READAMOUNT1 int,
READDATETME2 datetime,
READAMOUNT2 int
);
INSERT SMARTMETER VALUES
(1, '20240501 01:00', 100, '20240501 02:00', 120),
(1, '20240502 01:00', 110, '20240502 02:00', 115);
SELECT s.METERNUM, x.READDATETME, x.READAMOUNT
FROM SMARTMETER AS s
CROSS APPLY
(
VALUES(READDATETME1, READAMOUNT1),
(READDATETME2, READAMOUNT2)
) AS x(READDATETME, READAMOUNT)
ORDER BY s.METERNUM, x.READDATETME;
| METERNUM | READDATETME | READAMOUNT |
|---|---|---|
| 1 | 2024-05-01 01:00:00.000 | 100 |
| 1 | 2024-05-01 02:00:00.000 | 120 |
| 1 | 2024-05-02 01:00:00.000 | 110 |
| 1 | 2024-05-02 02:00:00.000 | 115 |