广仁 国网对接 SQL
SELECT Physics2,matFactoryDate,mtsManufacturer,mtsPatch,tadQualityNum,lName,mtsNum,mfName,etName,mfSpec,C,Si,Mn,P,S,V,Nb,Ti,YieldPoint,TensileStrength,Elongation,ImpactTest,ImpactTest1,ImpactTest2,mtDate as DETECTION_TIME,ItemStr3 as DETECTION_USER
FROM ..dbo.q_materialTestReportView
whereWriteDate > DATEADD(mm, -6, getdate()) and mfSpec='∠220*26'
GROUP BY Physics2,matFactoryDate,mtsManufacturer,mtsPatch,tadQualityNum,lName,mtsNum,mfName,etName,mfSpec,
C,Si,Mn,P,S,V,Nb,Ti,YieldPoint,TensileStrength,Elongation,ImpactTest,ImpactTest1,ImpactTest2,mtDate,ItemStr3 ORDER BY mtDate desc
SELECT * FROM ..dbo.f_taskpart a INNER JOIN ..dbo.F_MaterialDetail b ON a.mdid=b.mdID WHEREa.scdID=45059 ORDER BY a.tpsectName,tpPartsID 本帖最后由 李维强-15级 于 2023-11-1 23:24 编辑
添加锌锅温度
BEGIN
SELECT * INTO #myTemp from (SELECT TOP 40000 row_number() over(ORDER BY feedingTime desc) as Num, machineName,feedingTime,,WriteTime FROM ..dbo.TemperatureOfGalvanize ) as a;
INSERT INTO..dbo.TemperatureOfGalvanize (machineName,feedingTime,,WriteTime)SELECT machineName, DATEADD(minute,Num+Num-1, feedingTime) as feedingTime,,DATEADD(minute,Num+Num-1, WriteTime) as WriteTime FROM #myTemp;
DROP TABLE #myTemp;
end
国网在线问题文档
https://docs.qq.com/form/page/DZG5Nckp5VFpSaU5j
页:
[1]