主要是统计每月中每天的产出数据,不能直接取日期然后GROUPBY,那样得出的数据不准确,目前想法是先按班别查出每天白夜班的数,然后用循环去写入到一个临时表里,再从临时表里查,思路...
主要是统计每月中每天的产出数据,不能直接取日期然后GROUP BY,那样得出的数据不准确,目前想法是先按班别查出每天白夜班的数,然后用循环去写入到一个临时表里,再从临时表里查,
思路我知道,但SQL存储过程实在写不出来,求大神帮帮改改sql ,
------------------sql ---------------------------------------------
select '2017-08-08' as dates, '白天'as day_or_night,sum(qty) from smt_Efficiency_New where process='SMT'
and EndTime >='2017-08-08 08:00:00' and EndTime <= '2017-08-08 20:30:00'
and pdline in (SELECT distinct line
FROM smt_predit_product_list sppl,(SELECT linename FROM smt_c_line scl WHERE del_flag=0) lf
WHERE sppl.line NOT like 'S3%' AND sppl.DATEs='2017-08-08' AND sppl.day_or_night='白班'
AND (sppl.type NOT LIKE '%无排程%') AND (sppl.type NOT LIKE '%小板%') AND (sppl.type <> 'FRU')
AND (sppl.type <> '试产') AND (sppl.type <> '设备年保养') AND (sppl.type <>'设备月保养')
AND sppl.line=lf.linename);
---------------------查出结果-------------------------------------------
'2017-08-08', '白天', '27065'
展开