重用SQL备份

select EquipmentID,[concentration],[instantFlow],[outputQuantity],[pressure],[temperature],ColTime 
from (select a.EquipmentID,
[FieldName],
FieldValue,
ColTime
from KS_EquipRec201703 a
left join KS_DAttribute b
on a.DPrcArrID=b.AttrID) pvt pivot (max(FieldValue) for 
FieldName in ([concentration],[instantFlow],[outputQuantity],[pressure],[temperature])) a


select * from (
select em.RamCode,em.EquipMentName,us.ID as UserID,us.Name as UserName,cla.ClassID,cla.CategoryName as ClassName,sit.SiteID,sit.SiteName,
--round(dr.StaRecCumAmt,0) as StaRecCumAmt,
--round(dr.StaRecInsCumAmt,0) as StaRecInsCumAmt,
--round(dr.WorRecCumAmt,0) as WorRecCumAmt,
--ROUND(dr.WorRecInsCumAmt,0) as WorRecInsCumAmt,
--round(dr.RecPressure,0) as RecPressure,
--round(dr.RecTemperature,0) as RecTemperature,
--round(dr.RecConcentration,0) as RecConcentration,
usn.CategoryName as NatureName,pud.ProvinceName+cud.CityName+diu.DistrictName as DistrictName,
--dr.ColTime,
emm.ManagerID,
a.EquipmentID,[concentration],[instantFlow],[outputQuantity],[pressure],[temperature],ColTime 
from (select a.EquipmentID,
[FieldName],
FieldValue,
ColTime
from KS_EquipRec201703 a
left join KS_DAttribute b
on a.DPrcArrID=b.AttrID) pvt pivot (max(FieldValue) for 
FieldName in ([concentration],[instantFlow],[outputQuantity],[pressure],[temperature])) a                                       --历史数据


left join KS_EquipMent em on em.EquipMentID=a.EquipMentID         --设备
left join KS_Site sit on sit.SiteID=em.SiteID                      --站点
left join KS_AreaUser us on us.ID=sit.UserID                       --用户
left join KS_Product pro on pro.ProductID=em.ProductID             --产品
left join KS_Class cla on cla.ClassID=pro.ClassID                  --类别
left join KS_UserNature usn on usn.UserID=em.UserNatureID          --性质
left join KS_Districts_Used diu on diu.DistrictID=us.DistrictID    --区
left join KS_Citys_Used cud on cud.CityID=diu.CityID               --市
left join KS_Provinces_Used pud on pud.ProvinceID=cud.ProvinceID
left join KS_EquipMent_Manager emm on emm.EquipMentID = em.EquipMentID
left join KS_Manager mr on emm.ManagerID=mr.ManagerID
left join KS_Role ro on mr.RoleID=ro.RoleID )a where (1=1)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值