SQLServer列转行

最新推荐文章于 2023-06-19 18:51:10 发布

jsboy123

最新推荐文章于 2023-06-19 18:51:10 发布

阅读量240

点赞数

本文链接：https://blog.csdn.net/jsboy123/article/details/76686946

版权

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