CREATE TABLE #tt ( id int identity(1,1), AcquisitionTime datetime, mp1 varchar(200), mp2 varchar(200), mp3 varchar(200), mp4 varchar(200), mp5 varchar(200), mp6 varchar(200))INSERT INTO #tt(AcquisitionTime,mp1,mp2) SELECT AcquisitionTime ,MAX(CASE WHEN MPId=165 THEN Value END) ,MAX(CASE WHEN MPId=168 THEN Value END) FROM A GROUP BY AcquisitionTime类似这样
(
id int identity(1,1),
AcquisitionTime datetime,
mp1 varchar(200),
mp2 varchar(200),
mp3 varchar(200),
mp4 varchar(200),
mp5 varchar(200),
mp6 varchar(200))INSERT INTO #tt(AcquisitionTime,mp1,mp2)
SELECT AcquisitionTime
,MAX(CASE WHEN MPId=165 THEN Value END)
,MAX(CASE WHEN MPId=168 THEN Value END)
FROM A
GROUP BY AcquisitionTime类似这样