将一行拆分为更多行-表转换

INSERT INTO dbo.line_sensor_value(UTC, line_no, sensor_no, sensor_value)select UTC, line_no, sensor_no, temperature_1 as sensor_value from dbo.Dataunionselect UTC, line_no, sensor_no, temperature_2 as sensor_value from dbo.Dataunionselect UTC, line_no, sensor_no, temperature_3 as sensor_value from dbo.Dataunionselect UTC, line_no, sensor_no, temperature_4 as sensor_value from dbo.Data