Go
If exists (select * from ug.dbo.sysobjects 
  where  id = object_id(N'[ug].[dbo].[result]') and 
        (type='U' OR xtype='U') )
  DROP TABLE u70g18.dbo.result  -- Удалим старую результирующую таблицу
 
GO
Create table u70g18.dbo.result 
  (t float,cu1_y1 float,cu1_y2 float,cu1_y3 float,
           cu2_y1 float,cu2_y2 float,cu2_y3 float,
    cu3_y1 float,cu3_y2 float,cu3_y3 float,
    cu4_y1 float,cu4_y2 float,cu4_y3 float) 
GO
Insert into ug.dbo.result  
    (id,t, 
    cu1_y1, cu1_y2, cu1_y3,
    cu2_y1, cu2_y2, cu2_y3,
    cu3_y1, cu3_y2, cu3_y3,
    cu4_y1, cu4_y2, cu4_y3)
Select  tt.id,tt.t,
    m1.y1,m1.y2, m1.y3,
    m2.y1,m2.y2, m2.y3,
    m3.y1,m3.y2, m3.y3,
    m4.y1,m4.y2, m4.y3
From (select e.t,e.id from ug.dbo.experime e join ug.dbo.model m on e.id=m.id and m.[check]> 0  Group by e.t,e.id) tt
 left join ug.dbo.experime m1 on tt.t=m1.t and m1.id=tt.id and m1.id= 1 
 left join ug.dbo.experime m2 on tt.t=m2.t and m2.id=tt.id and m2.id= 2 
 left join ug.dbo.experime m3 on tt.t=m3.t and m3.id=tt.id and m3.id= 3 
 left join ug.dbo.experime m4 on tt.t=m4.t and m4.id=tt.id and m4.id= 4 

GO

Create table result 
  (t float,cu1_y1 float,cu1_y2 float,cu1_y3 float,
           cu2_y1 float,cu2_y2 float,cu2_y3 float,
    cu3_y1 float,cu3_y2 float,cu3_y3 float,
    cu4_y1 float,cu4_y2 float,cu4_y3 float) 

SELECT experiment.t, experiment.id, model.check
FROM experiment LEFT JOIN model ON experiment.id = model.id
WHERE model.check=True
ORDER BY experiment.t, experiment.id;

Insert into result  
    (id,t, 
    cu1_y1, cu1_y2, cu1_y3,
    cu2_y1, cu2_y2, cu2_y3,
    cu3_y1, cu3_y2, cu3_y3,
    cu4_y1, cu4_y2, cu4_y3)
Select  tt.id,tt.t,
    m1.y1,m1.y2, m1.y3,
    m2.y1,m2.y2, m2.y3,
    m3.y1,m3.y2, m3.y3,
    m4.y1,m4.y2, m4.y3
From TempQuery, tt <- нужна ли запятая
 left join experiment m1 on tt.t=m1.t and m1.id=tt.id and m1.id= 1  <- что это такое
 left join experiment m2 on tt.t=m2.t and m2.id=tt.id and m2.id= 2 
 left join experiment m3 on tt.t=m3.t and m3.id=tt.id and m3.id= 3 
 left join experiment m4 on tt.t=m4.t and m4.id=tt.id and m4.id= 4