重用SQL备份
来源:互联网 发布:重庆seo外包费用 编辑:程序博客网 时间:2024/05/06 15:44
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)
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)
0 0
- 重用SQL备份
- mybatis. <sql>元素重用
- 备份sql
- sql备份
- SQL备份
- SQL备份
- SQL备份
- sql server备份sql
- Qt中My SQL重用的问题
- sql备份数据库语句:SQL备份语句
- SQL Server备份、完整备份,差异备份、日志备份
- SQL*Server 备份策略
- SQL SERVER知识点备份
- SQL异地备份
- 关于sql在线备份
- 备份SQL Server
- 备份SQL数据库
- sql备份语句总结
- iOS API生成工具
- js封装原生态的ajax
- Xcode8后coreData的使用简介
- ORA-27100 shared memory realm already exists
- Nuget服务的搭建-打包-上传-删除
- 重用SQL备份
- python -- DNS处理模块
- 微信开发——网页授权获取用户基本信息
- Android实现沉浸式(透明)状态栏(Eclipse版)
- editview 被输入框遮住的解决办法
- 在viewpager的fragment里面填一个fragment里的RecyleView的点击事件
- 链表划分
- android 如何管理打开的多个Activity AppManager
- android studio 导入项目