SQLServer列转行

  insert into [KS_DataBase2016].dbo.KS_EquipRec20160817 select 
  a.EquipMentID,da.AttrID,a.AttributeValue,a.ColTime from (SELECT EquipMentID,ColTime,AttributeName,AttributeValue
  FROM [KS_DataBaseSX].[dbo].[KS_DataRecord] 
 UNPIVOT(
 AttributeValue for AttributeName IN
([StaRecCumAmt]
      ,[StaRecInsCumAmt]
      ,[WorRecCumAmt]
      ,[WorRecInsCumAmt]
      ,[RecPressure]
      ,[RecTemperature]
      ,[RecConcentration])
 ) AS unpvt
 where ColTime >= '2016-08-17' and ColTime < '2016-08-18' and AttributeValue >0) a 
  left join [KS_DataBaseSX].[dbo].[KS_EquipMent] em on a.EquipMentID = em.EquipMentID
  left join [KS_DataBaseSX].[dbo].[KS_Product] p on em.ProductID = p.ProductID
  left join [KS_DataBaseSX].[dbo].[KS_Class] c on p.ClassID = c.ClassID
  left join [KS_DataBase3.0].[dbo].[KS_Import_temp] i on a.AttributeName = i.AttributeName and p.ClassID = i.ClassID
  left join [KS_DataBase3.0].[dbo].[KS_DAttribute] da on da.FieldName = i.FieldName and da.ClassID = i.ClassID